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.

 

[bhicks11 via AccessMonster.com]

Hi,

Please give a little more clear detail. You mentioned filtering on a form or
query and then you talk about running a report. Do you want the data
filtered before you enter the form or after keying the data in the form? Do
you want popups to select data for the report? It's hard to follow.

Bonnie
http://www.dataplus-svc.com

 

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

 

[bhicks11 via AccessMonster.com]

You could design a form with two date fields to file in - the first being
the beginning date and the second being the end date. When you move off the
end date field (On Exit event), open your form and add the filter to the
onfilter criteria based on the first form (date =>forms!firstform.startdate
and date=< forms!firstform.enddate). I often do this for batch editing.

Bonnie
http://www.dataplus-svc.com

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.

Hi,

[quoted text clipped - 15 lines]