Parameter query (1 parameter, multiple sources)

[japhib]

I have one table and two queries that all have "Name" and "Date" columns in common. The date column contains the month and year for each name. Initially, I created a query that contained the 1 table and 2 queries based on the parameter "Name" and a separate parameter for "Date." The date columns of all three were in the query with the same parameter criteria statement [Enter Month and Year:] and linked together with an equal join property. Consequently, when you entered the month and year, the query pulled only that month and year from the 1 table and 2 queries by the name you chose. However, when we changed over from Access 2000 to Access 2003, the query no longer works. Any ideas why!

 

[Andrew Fergus]

Hello and welcome to Mr Excel.

Have you checked the field types (in the table design screen) were correctly converted? Also, check the date formats in your tables and queries.

What exactly is going wrong? Are you getting an error message or is the query not returning the results you expect?

Andrew

 

[japhib]

yes, I checked the date formats on all the tables and queries and they are the same. When I run the query now, I just get the column headings with no data.

 

[Andrew Fergus]

The issue is going to be one of two things : either there is no data in the table, or the query criteria is filtering out all of the records. Try removing the criteria from the query and see what a happens. Try re-introducing the criteria, paying attention to the underlying data format when you enter the criteria, and then see what happens. In particular, check the format of the field for which there criteria and make sure you enter in the values in the correct format.
HTH, Andrew.