Include Query in report that requires a value from the report

[jnmunsey]

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

I made a query that adds up the dollar amounts for all rev#s for each quote#, so if there was a Quote# 1234 revA, 1234 revB, and 1234 revC, each with $500, the query would return $1500 for that quote number. It also returns the other records..

I need to make a report that lists values from the fields of primary/first quote# and then lists the value from the query corresponding to that quote number.

I am lost. Please help. Note I am not very familiar with many of Access' functions etc so please try to explain as best possible.

Thanks

John M

 

[AndyS48UK]

John

Not sure how clear your question is so it may be easier to get a response by breaking down the problem.

Can you use the report wizard, select all the fields from your query...the wizard will then ask you for Grouping Levels and you could then use the quote as the Grouping Level?

Andy

 

[jnmunsey]

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