I'm making a start in Cogon 10. I want to know how to get the value of the prompt from question 1 and use it Query2 requires that I want to ask that year for which I want to query in query 1 and enter in the query 2 prompt me Data related to last year was made How to do it
You can use the same parameter (connected to the prompt) in the filter in both queries. If your parameter parameter is 1 and has a four digit year, and your data item [year] in your filter, then your Query1 filter may look like this:
[year] =? Parameter 1? Your Query2 filter will be:
[year] =? Parameter 1? - 1 Depending on your data source, you have to put the string parameter before integer, although most SQL implementations will convert string parameters to an integer for you.
No comments:
Post a Comment