Recent content by jnmunsey

NEVER MIND looks like I figured it out.. Thanks Is there any way to do this in one query? Thx John M _____________- Hi, not sure what you mean by "Int he next field type:" Which field?? Please be a little more specific. I appreciate the 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...

Thanks I think that did it.. That seems to work, though I need to include the time or it will return all records that have the same date... Thanks again!

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

Well the table currently only has two fields - QuoteID and QuoteComments, so how would a separate table be of any benefit? It already is in its own table and is linked to the main table. Does there not have be a field(QuoteID) to identify which QuoteID in the main table the comments belong...

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

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

I figuured it out Thanks for the reply. I just made a subreport(s) that accessed the queries I built. I did not realize Access would synch the keys up as well.. It worked nicely..

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