individual data and summation

[jarheadjim]

I apologize in advance if this has been covered, I couldn't find what I was looking for by searching.

I have a fairly simple database that is storing subcontractor & spending data. I want to be able to select a job# and display all the data that pertains to it. This part works fine, but I can't seem to get the totals for estimates and actual to work.

The only way I could make it work was to have a report based on a select query and then a subreport where i requery the select query...this gets me the correct results, but I have to enter the job# 3 times in a row

Any push in the right direction would be great.

Thanks,

Jim

 

[SamDeMan]

your parameter for each of the queries should be a text box thats on a form, so that you don't need to enter it 3 times.

sam

 

[jarheadjim]

I guess i don't understand, I open the report and it gives me a prompt. I enter the # and press ok. I'll have to try using a form and get back to you. Thanks

Edit - It is only one parameter (Job#) that will be used to filter the data. I couldn't figure out how to make it work from a form. It sux being the dumb guy

 

[SamDeMan]

i am not sure where your promt is, but somewhere along the way (either in a query or in a report) there is a promt. that promt in design view is in the criteria or something like that. you need to direct that parameter to a form. so it would be criteria: Forms![MyForm]![MyDataField]

try to look around for a sample of this. should not be too difficult to find.

good luck,

sam