S
Superlan
I need to create a report based on a table with multiple check boxes but the
user should be able to specify which fields they want to see in the report.
I have seen, here in these discussions, a thread for my question, but I am
never sure if the syntax given in the replies pertain specifically to the
database of the person asking the question, or if the code is generic in
nature and the reader should attempt to substitute field names, etc. I also
have not been able to follow exactly what needs to be created (queries,
forms, buttons, etc., OR in what order) for the report to work, and where the
code should be written.
I am familiar with Access and how to create and use all the objects, and I
use fairly complicated formulas to manipulate data and produce meaningful
information. Although I don't normally use SQL I can usually follow code and
I have successfully edited such files. For my database, however, I am missing
some key piece to make it all come together. Please be patient with me....
The simple version of my database is as follows:
The table name is ALL APPLICANTS
The first fields are [CITY1], [CITY2], etc. thru [CITY5]. They are number
fields and the data is a single digit ranging from 0 to 5 (a preference
rating)
The next fields are check boxes named [DATE01], [DATE02], etc thru [DATE14]
Another check box field is [14DAYS]
The Tag Property of all check boxes on the form are named the same as the
field names
There is also an [ELECTIONDATE] date formatted field to select specific
dates (lookup from the ELECTIONS table)
All of these fields are in the same table. The data is input through a form
(EARLY VOTING FORM) and the user simply checks the appropriate boxes that are
indicated from a hard copy filled out by potential temp emps.
The [CITYx] field rates what city a temporary employee can work at. Multiple
cities can be chosen and then rated as follows: nothing=won't work there,
0=no preference, 1 thru 5=preference with 1 as the highest value.
The [DATExx] check boxes indicate on what days they can work leading up to
an election. Multiple dates can be selected.
The [14DAYS] check box is used if the employee can work all 14 dates, thus
negating the need to populate all the [DATExx] check boxes.
I would like the user to be able to produce a report by selecting:
[ELECTIONDATE] - the date of the election
[CITYx] - choose a city but NOT include NULL values
[DATExx] - dates available for work if [14DAYS] isn't checked or
[14DAYS] -
Other fields (name, phone, etc.) will also be included in the report
If possible, ranking the [CITYx] from lowest to highest would be good, but
not necessary.
[ELECTIONDATE] would always be the first sort, but then the focus of the
report might be by [CITYx], or by [DATExx], or by [14DAYS], depending on what
user is making the request. Perhaps 3 reports are needed?
If it isn't too much to ask, (and I TRULY! appreciate any help), please
indicate all the steps necessary to accomplish this task.
Please let me know if I have left out any info. Thanks so much for your help!!
Superlan
user should be able to specify which fields they want to see in the report.
I have seen, here in these discussions, a thread for my question, but I am
never sure if the syntax given in the replies pertain specifically to the
database of the person asking the question, or if the code is generic in
nature and the reader should attempt to substitute field names, etc. I also
have not been able to follow exactly what needs to be created (queries,
forms, buttons, etc., OR in what order) for the report to work, and where the
code should be written.
I am familiar with Access and how to create and use all the objects, and I
use fairly complicated formulas to manipulate data and produce meaningful
information. Although I don't normally use SQL I can usually follow code and
I have successfully edited such files. For my database, however, I am missing
some key piece to make it all come together. Please be patient with me....
The simple version of my database is as follows:
The table name is ALL APPLICANTS
The first fields are [CITY1], [CITY2], etc. thru [CITY5]. They are number
fields and the data is a single digit ranging from 0 to 5 (a preference
rating)
The next fields are check boxes named [DATE01], [DATE02], etc thru [DATE14]
Another check box field is [14DAYS]
The Tag Property of all check boxes on the form are named the same as the
field names
There is also an [ELECTIONDATE] date formatted field to select specific
dates (lookup from the ELECTIONS table)
All of these fields are in the same table. The data is input through a form
(EARLY VOTING FORM) and the user simply checks the appropriate boxes that are
indicated from a hard copy filled out by potential temp emps.
The [CITYx] field rates what city a temporary employee can work at. Multiple
cities can be chosen and then rated as follows: nothing=won't work there,
0=no preference, 1 thru 5=preference with 1 as the highest value.
The [DATExx] check boxes indicate on what days they can work leading up to
an election. Multiple dates can be selected.
The [14DAYS] check box is used if the employee can work all 14 dates, thus
negating the need to populate all the [DATExx] check boxes.
I would like the user to be able to produce a report by selecting:
[ELECTIONDATE] - the date of the election
[CITYx] - choose a city but NOT include NULL values
[DATExx] - dates available for work if [14DAYS] isn't checked or
[14DAYS] -
Other fields (name, phone, etc.) will also be included in the report
If possible, ranking the [CITYx] from lowest to highest would be good, but
not necessary.
[ELECTIONDATE] would always be the first sort, but then the focus of the
report might be by [CITYx], or by [DATExx], or by [14DAYS], depending on what
user is making the request. Perhaps 3 reports are needed?
If it isn't too much to ask, (and I TRULY! appreciate any help), please
indicate all the steps necessary to accomplish this task.
Please let me know if I have left out any info. Thanks so much for your help!!
Superlan