Question about forms | | |
I have a table set up as follows
name,class,date1,time1,date2,time2...date10,time10
I am trying to create a report that would pull up, based on an entered
date, the class, name, and time of the exam.
| | | | re: Question about forms
Why do you need some many date fields?
You can create a query, and under criteria create a parameter that
prompts you for a date. Then use that query for your report, when you
run the report it will prompt for a date and once a date is entered it
will return only the information that you want relating to the date
entered. tracy.cooperjr@gmail.com wrote: Quote:
I have a table set up as follows
>
name,class,date1,time1,date2,time2...date10,time10
>
I am trying to create a report that would pull up, based on an entered
date, the class, name, and time of the exam.
| | | | re: Question about forms
The reason is this. When I created the form it was supposed to be used
such that a persons name and class are entered and then every date and
time of the exam would be entered. I used 10 dates and times because
there may be up to ten tests throughout the semester. Did I do a bad
thing? should I try using a subform? Any help will be appreciated.
gumby wrote: Quote:
Why do you need some many date fields?
>
You can create a query, and under criteria create a parameter that
prompts you for a date. Then use that query for your report, when you
run the report it will prompt for a date and once a date is entered it
will return only the information that you want relating to the date
entered.
> tracy.cooperjr@gmail.com wrote: Quote:
I have a table set up as follows
name,class,date1,time1,date2,time2...date10,time10
I am trying to create a report that would pull up, based on an entered
date, the class, name, and time of the exam.
| | | | re: Question about forms
tracy.cooperjr@gmail.com wrote: Quote:
The reason is this. When I created the form it was supposed to be used
such that a persons name and class are entered and then every date and
time of the exam would be entered. I used 10 dates and times because
there may be up to ten tests throughout the semester. Did I do a bad
thing? should I try using a subform? Any help will be appreciated.
Any time you have repeating groups of data for a single record,
something's wrong. The dates/times should go into a child table. or
if you really feel like having fun, try writing SQL statements to do
averages across several fields. I just think that doing it the way you
are doing it is heading for trouble. | | | | re: Question about forms
Yes you need to setup two tables. Probably one with all the persons
info and the other with all the test info, but only one time. For
instance only one date field, one time field, one score field, and so
one.
Link the two fields most likey the person name with a TestID number.
TestID could be the name of one of fields in your second table. Check
out this template by Microsoft. http://office.microsoft.com/en-gb/te...366821033.aspx
View the relationships under tools. This will get you started in
setting up your tables correctly. tracy.cooperjr@gmail.com wrote: Quote:
The reason is this. When I created the form it was supposed to be used
such that a persons name and class are entered and then every date and
time of the exam would be entered. I used 10 dates and times because
there may be up to ten tests throughout the semester. Did I do a bad
thing? should I try using a subform? Any help will be appreciated.
>
gumby wrote: Quote:
Why do you need some many date fields?
You can create a query, and under criteria create a parameter that
prompts you for a date. Then use that query for your report, when you
run the report it will prompt for a date and once a date is entered it
will return only the information that you want relating to the date
entered. tracy.cooperjr@gmail.com wrote: Quote:
I have a table set up as follows
>
name,class,date1,time1,date2,time2...date10,time10
>
I am trying to create a report that would pull up, based on an entered
date, the class, name, and time of the exam.
| | | | re: Question about forms
Cool Thanks
gumby wrote: Quote:
Yes you need to setup two tables. Probably one with all the persons
info and the other with all the test info, but only one time. For
instance only one date field, one time field, one score field, and so
one.
>
Link the two fields most likey the person name with a TestID number.
TestID could be the name of one of fields in your second table. Check
out this template by Microsoft.
> http://office.microsoft.com/en-gb/te...366821033.aspx
>
View the relationships under tools. This will get you started in
setting up your tables correctly.
>
>
> tracy.cooperjr@gmail.com wrote: Quote:
The reason is this. When I created the form it was supposed to be used
such that a persons name and class are entered and then every date and
time of the exam would be entered. I used 10 dates and times because
there may be up to ten tests throughout the semester. Did I do a bad
thing? should I try using a subform? Any help will be appreciated.
gumby wrote: Quote:
Why do you need some many date fields?
>
You can create a query, and under criteria create a parameter that
prompts you for a date. Then use that query for your report, when you
run the report it will prompt for a date and once a date is entered it
will return only the information that you want relating to the date
entered.
> tracy.cooperjr@gmail.com wrote:
I have a table set up as follows
name,class,date1,time1,date2,time2...date10,time10
I am trying to create a report that would pull up, based on an entered
date, the class, name, and time of the exam.
|  |
Similar Microsoft Access / VBA bytes | | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,295 network members.
|
