Search results

  1. J

    Need query help...

    I have two tables: MAIN -quotenumber -quoteamount REVISIONS -quotenumber -revisionnumber -quoteamount I want to get a total sum of quote amounts for each quote number from both tables grouped by quote number i.e. MAIN 00012 $100 00013 $45 00014 $90 REVISIONS 00012 REVA $50 00012...
  2. J

    linked subform data does not change when master is changed

    I have master and sub forms whose data is from the same table but the forms each get their data from queries that separate the data. Essentially the subform data has the same fields as the main form data. Separating each into separate tables is a difficult option at the moment - too many other...
  3. J

    Query does not return records with empty fields

    EDIT - Looks like I found it - use the Nz function SELECT ID,
  4. J

    Return the LAST records for EACH of a particular field?

    I need to do the following: I have a table named QuoteLog. It has a "QuoteID" field(duplicates allowed) and a "QuoteComments" field. Each QuoteID can have multiple QuoteComments, so you could have QuoteID 1234 exist 10 times with comments for each.. I want to return the LAST record for each...
  5. J

    Include Query in report that requires a value from the report

    Hi, I am new here and read through all the posts, but there is quite a bit of stuff in here to sort through, so I will post my problem here. Using Access 97, I have a table that contains a quote# and rev# - together they are the primary key. Each record has a dollar amount in a field called...
Back
Top Bottom