Results 1 to 6 of 6
  1. 11-17-2011, 05:33 AM #1
    Lois
    Lois is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    15

    Queries only Picking up some information

    Hi,


    why does my Job List Query only pick up some of the order numbers on the job list table & not them all??!
    Reply With Quote Reply With Quote
  2. 11-17-2011, 06:57 AM #2
    hertfordkc
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Quick guess without opening your DB: There are nulls in some record fields for which you've specified a criteria. One solution might be to use the NZ function in calculated fields to temporarily replace the null values.
    Reply With Quote Reply With Quote
  3. 11-17-2011, 07:01 AM #3
    Rainlover's Avatar
    Rainlover
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    I can't open 2007 but my guess is that the joins in the query are wrong.

    Guess Only.
    Reply With Quote Reply With Quote
  4. 11-17-2011, 08:27 AM #4
    hertfordkc
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    I don't understand your question. It worked for me.

    Quote Originally Posted by Lois View Post
    Hi,
    why does my Job List Query only pick up some of the order numbers on the job list table & not them all??!
    __________________________________________________ __________

    Did you mean to refer to your test query????
    Reply With Quote Reply With Quote
  5. 11-22-2011, 02:51 AM #5
    Lois
    Lois is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    15
    Quote Originally Posted by hertfordkc View Post
    Quick guess without opening your DB: There are nulls in some record fields for which you've specified a criteria. One solution might be to use the NZ function in calculated fields to temporarily replace the null values.
    how do i do that?
    Reply With Quote Reply With Quote
  6. 11-22-2011, 05:08 AM #6
    Rainlover's Avatar
    Rainlover
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    There are 23 records in both the Query abd the Table.

    Nothing is missing from the Query.

    They are missing from the Table.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Picking up Date on Import
    By DonL in forum Import/Export Data
    Replies: 4
    Last Post: 08-10-2011, 07:06 AM
  2. Combo box not picking up values basis dlookup
    By amangupts in forum Programming
    Replies: 13
    Last Post: 07-15-2011, 11:03 AM
  3. Dsum calculation is only picking up a single record
    By randomaccess in forum Forms
    Replies: 4
    Last Post: 06-02-2011, 02:32 PM
  4. Me not picking up new columns in table
    By asterismw in forum Programming
    Replies: 3
    Last Post: 03-11-2011, 02:00 PM
  5. Where can I get more information on this pls?
    By Buakaw in forum Programming
    Replies: 6
    Last Post: 02-12-2011, 04:39 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums