How do i create a report to be used as a form to track attendance?

[hshapiro5]

i need to create a report/form that i can hand out that will contain the
following;
class [this would be from a query] Lname Fname 11/02 11/09 11/16
the date fields would have a box below each date [] [] [], woul
like to have the date ncrement by 7 for 1 quarter. i would print this form
each quarter and wuld like the dates to change for me.

 

[Duane Hookom]

Do you actually have the dates as fields in your query? Are there always the
same number of dates in a quarter?

If you have a form (frmDates) with a text box (txtStartDate), you can
generate column headings/label in your report with text boxes having Control
Sources like:
=Forms!frmDates!txtStartDate
=Forms!frmDates!txtStartDate + 7
=Forms!frmDates!txtStartDate + 14

 

[hshapiro5]

Having trouble, am new to access, do i need to have a table created first?
do i have specific dates? if i create the form as you mentioned where do i
enter the starting dat e. would also like to track the data created from the
handout.

Do you actually have the dates as fields in your query? Are there always the
same number of dates in a quarter?

If you have a form (frmDates) with a text box (txtStartDate), you can
generate column headings/label in your report with text boxes having Control
Sources like:
=Forms!frmDates!txtStartDate
=Forms!frmDates!txtStartDate + 7
=Forms!frmDates!txtStartDate + 14

--
Duane Hookom
Microsoft Access MVP

i need to create a report/form that i can hand out that will contain the
following;
class [this would be from a query] Lname Fname 11/02 11/09 11/16
the date fields would have a box below each date [] [] [], woul
like to have the date ncrement by 7 for 1 quarter. i would print this form
each quarter and wuld like the dates to change for me.

 

[Duane Hookom]

Maybe you should start over with your requirements. Have you created any
tables? What do you what your application to do?

--
Duane Hookom
Microsoft Access MVP

Having trouble, am new to access, do i need to have a table created first?
do i have specific dates? if i create the form as you mentioned where do i
enter the starting dat e. would also like to track the data created from the
handout.

Do you actually have the dates as fields in your query? Are there always the
same number of dates in a quarter?

If you have a form (frmDates) with a text box (txtStartDate), you can
generate column headings/label in your report with text boxes having Control
Sources like:
=Forms!frmDates!txtStartDate
=Forms!frmDates!txtStartDate + 7
=Forms!frmDates!txtStartDate + 14

--
Duane Hookom
Microsoft Access MVP

i need to create a report/form that i can hand out that will contain the
following;
class [this would be from a query] Lname Fname 11/02 11/09 11/16
the date fields would have a box below each date [] [] [], woul
like to have the date ncrement by 7 for 1 quarter. i would print this form
each quarter and wuld like the dates to change for me.