Community of MapPoint and Virtual Earth Users and Developers
This is a discussion on using access 2003 queries as a data source within the MapPoint 2006/2009 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 ...
| |||||||
| Today's Posts | Twitter Feed | Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| using access 2003 queries as a data source Any ideas please? Roberta |
| |||
| using access 2003 queries as a data source
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 |
| |||
| Access Queries with wildcarded dates
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 |
![]() |
| Tags |
| 2003, access, data, queries, source |
| ||||
| Posted By | For | Type | Date | |
| *Clix | This thread | Refback | 02-26-2007 02:05 PM | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Custom Data source | Anonymous | MapPoint Web Service and Virtual Earth | 2 | 08-11-2005 03:25 PM |
| Question about Map Data Source | VincentSun | MapPoint 2006/2009 Discussion | 0 | 02-27-2005 08:37 PM |
| Which data source to use ? | Anonymous | MapPoint 2006/2009 Discussion | 0 | 07-07-2004 05:03 AM |
| [VB6 + ACCESS + MP] : How to change data source ? | Vincent BENNER | MapPoint 2006/2009 Discussion | 0 | 10-17-2002 02:35 AM |
| link data wizard won't let me use parameter queries | Anonymous | MapPoint 2006/2009 Discussion | 7 | 08-23-2002 10:14 AM |
Lanzarote Holiday
Enjoy a Lanzarote holiday when you check out the offers on UlookUbook and save cash!