Question about forms

[tracy.cooperjr]

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.

[gumby]

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.

tr************@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.

[tracy.cooperjr]

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:

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.

tr************@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.

[pietlinden]

tr************@gmail.com wrote:

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.

[gumby]

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.

tr************@gmail.com wrote:

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:

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.

tr************@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.

[tracy.cooperjr]

Cool Thanks
gumby wrote:

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.

tr************@gmail.com wrote:

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:

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.
>
tr************@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.