S
Sean
Hi, sorry about the confusing title.
What I am currently working on is a form which the user enters in *what*
data they want. Currently the form works like this. You enter in which
locations you want to show in a report. The locations you enter in are stored
in a table. A query matches up those locations with the locations stored in
the database which holds *all* the locations and their data. A report then
takes that information and displays it how I want.
1 - Form - User specificies locations they want to view
2 - Table1 - Locations & Data
3 - Table2 - User Selected Locations
4 - Query - Matches the locations the user selected with the data from the
table2
5 - Report - Generated from Query
I hope that explains well enough what I'm doing. Now, what I want to add to
that is a little more usability. For every location the user specifices, I
want to be able to control the number of records to show based upon most
recent records.
Example -
In the form the user inputs that they want to see the 6 most recent data
entries for location A1 and the 3 most recent for location 8B.
Ok..help
What I am currently working on is a form which the user enters in *what*
data they want. Currently the form works like this. You enter in which
locations you want to show in a report. The locations you enter in are stored
in a table. A query matches up those locations with the locations stored in
the database which holds *all* the locations and their data. A report then
takes that information and displays it how I want.
1 - Form - User specificies locations they want to view
2 - Table1 - Locations & Data
3 - Table2 - User Selected Locations
4 - Query - Matches the locations the user selected with the data from the
table2
5 - Report - Generated from Query
I hope that explains well enough what I'm doing. Now, what I want to add to
that is a little more usability. For every location the user specifices, I
want to be able to control the number of records to show based upon most
recent records.
Example -
In the form the user inputs that they want to see the 6 most recent data
entries for location A1 and the 3 most recent for location 8B.
Ok..help