Community of VE/MapPoint 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 ...
| |||||||
| 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 |
Flights to Reus
Book cheap flights to Reus on Holiday Hypermarket for a fantastic holiday in Costa-Dorada! Great weather, great shopping and great beaches.
Personal Travel Agent'
Whatever your travel needs your personal Travel Agent can help. Travel Counsellors are a Queen's Award winning Travel Agent
Cuba Holiday
A Cuba Holiday has so much to offer with numerous different cultures affecting the sights, sounds and tastes. Visit this fascinating country with dealchecker.co.uk.
Holidays to Dominican Republic
Holidays to Dominican Republic offer a wealth of natural beauty and magnificent views. Come alive in the splendor of the Dominican Republic!
Holidays
For bargain holidays to destinations including Mexico, South Africa, India and more, visit ULookUBook online today. Check out our free travel guides to help you make an informed decision for your holidays.
Cheap Inclusive
Make use of our service at Travel.co.uk to help you to research cheap inclusive holidays.
Goa Holidays
Enjoy the warm and sunny climate of Western India. Visit On The Beach for information on Goa holidays.