Results 1 to 3 of 3
  1. #1
    salisbut is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    52

    Can't get all records in query


    In the attached database, I have a frmSelection which picks the meter point and generates qrySelect, which generates multiple other queries. The problem is that there are three meter points Cascade Grain, Entire System and Georgia Pacific which are combinations of multiple meters. I tried an if statement in the meter# field which went something like IIf ( Forms![frmSelection]![cboMeterPoint] = "Cascade Grain", 3229 or 3230, [Meter #] ) and other variations but they do not seem to work. I understand I have organized the data poorly, but I don't think this should affect this particular problem. I have attached the database in the mdb format. Ah I can't seem to upload is there a problem with the website right now?

  2. #2
    dsmacs is offline Advanced Beginner
    Windows XP Access 2010 (version 14.0)
    Join Date
    Oct 2009
    Location
    Perth Western Australia
    Posts
    52
    Try a compact and repair first and then attached a zip file.

  3. #3
    salisbut is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    52
    Here is the database. Just to reiterate the earlier post, I would like to be able to grab two meters and sum them from them queries I have instead of creating numerous other queries (like qryCascadeGrain).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. The number of records in a query
    By Persist in forum Programming
    Replies: 3
    Last Post: 07-13-2010, 06:23 AM
  2. Return all records from Query
    By ysrini in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 09:52 PM
  3. How to Add New Records based upon Query?
    By SteveAb in forum Database Design
    Replies: 0
    Last Post: 08-06-2009, 10:24 PM
  4. Query two different records in the same table
    By Eildydar in forum Access
    Replies: 5
    Last Post: 04-15-2009, 01:39 PM
  5. query that will contain all unique records
    By halcolm1 in forum Queries
    Replies: 0
    Last Post: 01-19-2007, 05:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums