Hello, all. Darn near done with the project, and the last reporting needs are causing trouble.
First, I have to pull together data from 2 databases of different types. (Quickbooks, Access). Figured that out.
Now for the reporting, I have a split form that the users are already accustomed to using in Access for a different purpose, so I thought I would use it as the "selector" for the reports. Sounded like a good idea. User filters down to the items on which he/she would like to see the report data. The problem is I cannot figure out how to get the criteria to pass from the form to the queries.
The form holds a key field of ControlNumber, which is a number.
The other data sources have fields which hold the same number, albeit as TEXT. These fields are used as the join criteria.
Any idea how I can use the selections as the criteria in a query?
Thanks,
Stephen.