Lookups, Parameters

[acopper57]

I am new at this Access. I have a customer sales query built. Now I am
wondering whether I should be using parameters on the query itself to filter
info, or should I be doin that on the form.
Thought it was easier and faster to filter out needless info on query, then
running report.
Also, would I enter LOOKUPS to choose data (i.e.: accts by location, sales
by date, etc.). What is the easier and most efficient way to do this.

Appreciate any help with thi.

 

[acopper57]

Sorry Bonnie. Not sure which would be better. Would like user to be able to
choose "date range" as well as "hierachy" level on products table at the
query level. Right now, have the "Between [Forms]![Date Range].[Start Date]
And [Forms]![Date Range].[End Date]" selection on query, but don't know how
to create the form to select hierachy at the query level.

I would like to know how to select data through popups to select data on
report level as well, and see which would work better for me.

Much appreciate your patience with me, a newbie to this.