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

  • Thread starter Thread starter hshapiro5
  • Start date Start date
H

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.
 
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
 
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.


Duane Hookom said:
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


hshapiro5 said:
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.
Click to expand...
Click to expand...
 
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


hshapiro5 said:
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.


Duane Hookom said:
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


hshapiro5 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top