budget report

[Cesar]

Hello everybody, my problem is as follows:
I´m newby in Access and i was trying to make a report for budgets.
The form, the tables and its relationships are ok, but the problem is the
report.
The database scheme is the following:

Customer nº1------------>Budget Nº 1------------>Item nº1
| |
|----------->Item nº2
| |
| ------>Budget Nº2
| |--------->Item nº1
| ---------->Item nº 2
|
----> Customer nº2------ idem as above

When i build and show the report, it shows me the 1st customer, with the 1st
budget and its items, after that, the 2nd budget and its items, after that,
the 2nd customer and its budgets and items.
What i´m trying to do is that it simply shows the customer i´ve selected,
with the budget i´ve selected and its items, nothing more.
Now, the question is: can anybody tell me how to do that?. i mean, how to
limit the records i want to show, cause till now, i could not do it... :-(

Thanks in advance

César

 

[DevalilaJohn]

I'll make two assumptions:
1. you are running at least one query to develop the data
2. you have a form to run from

On your form add a combo box(s) for whatever criteria you want (e.g. for
customer), when you want a report select the criteria via the combos.

On the query, in the criteria cell of the query builder insert = controlName
where controlName is the name you give your combo box.

Then just hit your run button (the wizard will guide you through adding
that) and you have it.

 

[César]

uuhhmm... well, that's exactly what i didn't. please, explain me, how the
query should be? i suposse (based in what you said) that it is for select
the data i want to show, right?
I have a table with data about customers, another one for data specific of
the budgets (no. of budget, date, etc.) and another for items of each
budget. All of them with the corresponding relationships.
In the form all works perfectly, the problem is -as i said- the reports.
Thanks in advance for the assistance you can give me.