Query results to form

[psullivan348]

Okay, I am confused, frustrated and just want the answer
I have retyped this 10 times and still it is so confusing. Here is some history. I have 400 locations, each one is supposed to report "sales" on a quarterly basis. 80% of the locations add to their quarter ending sales, after they report the amounts to my office. So when the 2nd quarter reports are entered, the discrepancy between year to date is not caught until today when we are going through a audit and none of the year to date information is correct. So here is what I want and if some one understands and could help, I will be indebted to you forever!

I want a form that you enter the location, the fiscal year, the quarter and the sales amount.

Then (I have no idea how, this is where I need help) I need the year to date information for the location entered to displayed (read only) so the year to date information can be verified at that time. If the year to date sales are not correct, go back to that quarter and adjust the sales to get the year to date correct.

I have tried dlookup, I have tried query by form, I have tried everything I know but it seems like the amount that just got entered never shows up and I can not get both results on the screen at one time. I have watched videos, even went to training for 6 hours and still have no idea how to do this?

If someone could point me in the right direction, that would be fabulous!

 

[RuralGuy]

It can be done with a query. Use the query designer to create your select query and then start adding absolute criteria until you achieve at least one recordset you want and then come back here with the SQL for that query and we can take that to the next step. That would be replacing the absolute values you used with values from your form dynamically.