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
This is a discussion on using access 2003 queries as a data source within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a database which when I connect to - the datamapping wizard can see tables, but when I try ...
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![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)