Results 1 to 2 of 2
  1. #1
    mslieder is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2005
    Posts
    10

    Query - using Max Totals with Criteria

    Hello,

    I have a database with 2 tables. In one table, the Part Number is displayed. In another query, the Revision Letter is displayed (many revisions to one part number). My first problem was to run a query so the latest part number and revision is displayed. I used the Totals button and added "Max" to the Total section under Revision. That worked!

    Now there's another hitch. In the table displaying the Part Number, I have a field displaying the Lifecycle of the product. I need to sort this original query using criteria in the Lifecycle field. That seems to work as well. As soon as I add another field from my table (for instance, Writer), it's almost like it overrides the Max total because I am back to getting multiple part numbers again.

    Table 1
    Part Number Lifecycle
    123456 LC30
    124568 LC10
    124578 LC30


    Table 2
    Part Number Revision Writer
    123456 A Anne
    123456 B Anne

    124568 A Anne
    124568 B Vince
    124568 C Lucy



    124578 A Lucy
    124578 B Anne

    Any ideas?

    Thanks in advance,
    Anne

  2. #2
    BCJourney is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Location
    Cincinnati, OH
    Posts
    46
    It sounds like it may be a relationship issue. What type of join do you have between the tables? It would need a one-to-many relationship using part number as the primary and foreign key. the part number table would be on the one side and the table containing the revision writer would be on the many side.

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

Similar Threads

  1. Query Criteria
    By Texaine in forum Queries
    Replies: 1
    Last Post: 01-24-2018, 02:36 PM
  2. Query Criteria
    By jena in forum Access
    Replies: 1
    Last Post: 08-03-2008, 04:08 AM
  3. Query Criteria
    By jena in forum Queries
    Replies: 1
    Last Post: 04-29-2008, 11:00 AM
  4. Replies: 1
    Last Post: 03-15-2007, 03:38 PM
  5. query - totals
    By mslieder in forum Access
    Replies: 0
    Last Post: 02-22-2006, 06:11 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