How to list all names etc to Print

[alanfallow]

Hi wonder if someone can help.
I am in the process of doing an attendance register with name date and attendance y/n
I would like to print out a form or report with all names in a list with blank date attendance etc so i can manualy fill it in on the night then transfer into access. It will probably be easy but just not sure how.



Thanks again for any help.

[rpeare]

Just create a query showing the person's information then create two additional fields:

Attendance Date: date()
Present: null

so for each row of your query the attendance date will be visible (so if you compare attendance sheets you'll know which date you're looking at) and the PRESENT field will be blank basically giving you a 'box' in your printed query that you can check or write in the value.

[June7]

You want a blank document with names listed and boxes to represent days? Shouldn't be difficult. How many days?

I do this for a 2-week period. User inputs start date on form. Textboxes on report calculate each day based on the given start date. These calculated textboxes serve as the column headers in the report Header section.

Report RecordSource pulls names from table and lists them in Detail section of report.

The only real trick is passing the start date into the report and several ways to approach that. One way is a textbox on report that references the date textbox (or combobox) on form.

Data entry, however, will not look like the printed document.

EDIT: I see rpeare posted first and also noticed you want to do this daily so really need box for only 1 day and rpeare suggestion should be adequate

[alanfallow]

Hi Sorry its once a week at our scout meeting.

[June7]

That would still be a single day for marking attendance?

[alanfallow]

OK Thanks magic.

[June7]

But if you want to save paper, could set it up for multiple days and either calculate the dates or hand-write into blank boxes.

[alanfallow]

Hi i made a query then a report then add labels??

[June7]

Is that a question or just reporting what you accomplished?

[alanfallow]

No wasnt sure how to add extra fields in query.

[June7]

Don't really need the extra fields. But if you want them to show on printout and not have to write them, the SQL suggested by rpeare would look like:

SELECT LastName & ", " & FirstName AS ScoutName, Date() AS AttendDate, Null AS Present FROM tablename;

Access Help (and the web) has info on building queries and creating fields with expressions. Enter the expression on the Field row of the query design grid.

[alanfallow]

Ok thanks will have a go
Thanks for the help.