Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

using access 2003 queries as a data source

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 ...

  1. #1
    roberta walker is offline Junior Member White Belt
    Join Date
    Apr 2004
    Posts
    7

    using access 2003 queries as a data source

    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

  2. #2
    roberta walker is offline Junior Member White Belt
    Join Date
    Apr 2004
    Posts
    7

    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

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Custom Data source
    By Anonymous in forum Bing Maps and MapPoint Web Service
    Replies: 2
    Last Post: 08-11-2005, 04:25 PM
  2. Question about Map Data Source
    By VincentSun in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-27-2005, 09:37 PM
  3. Which data source to use ?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-07-2004, 06:03 AM
  4. [VB6 + ACCESS + MP] : How to change data source ?
    By Vincent BENNER in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-17-2002, 03:35 AM
  5. link data wizard won't let me use parameter queries
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 08-23-2002, 11:14 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96