I have a database which when I connect to - the datamapping wizard can see tables, but when I try to link to a query the query window is empty (the query runs ok in access).

Any ideas please?


Roberta

I have just answered my own question in case anyone is interested.

I had limited the dates showing in a date field using Like "*/*/2001" rather than Between 01/01/2001 And 31/12/2001. When I changed to the latter criteria it worked!!!!!

Roberta

Roberta

If you want to select all the dates within a single year, you might try using where year(date) = 2001

The function call may not be 100% accurate since I was replying off the top of my head but I believe a quick glance in the help should confirm the syntax. I was recently looking at some Access code I did in the 90s that used the year function and it seemed to work ok.

Best Regards
Anthony Case