Checkboxes based on query for report

[aamudog]

Hello,

I am not very familiar with Access but am trying to learn. I am trying to figure out the best way to create a weekly report. I would like the report to look like this:


Member Name Time In # guest Sun Mon Tue Wed Thu Fri Sat
Doe, Jane 2:00 PM 2 x x x x


Under each day I would like to have a check mark on the report if the member signed in that day. I have a query setup that returns the member name, time in, #guest and week and weekday. Can I use this query to enable/disable the checkboxes to create a weekly report in the format above? ANY help will be greatly appreciated.

This is how my tables are setup.

MemberTbl
MemberNum(PK) (text field)
MemFName (text field)
MemLName (text field)

SignInTbl
TimeID (PK) (AutoNumber)
MemberNum (text field)
dtmStamp (Date/Time)
NumGuest (Number)

 

[TheAceMan1]

How are ya aamudog . . .

Your having a definite tables & relationships problem. Have a look below:

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[dhookom]

I don't see anything un-normalized about the table structure.

aamudog,
Have you considered creating a crosstab query? Are the number of guests going to vary each date?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[TheAceMan1]

Howdy dhookom . . .

I'm relating to fitting the table data to the desired output format!

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[dhookom]

I'm still not sure how the table design needs changing. The desired report layout is fairly common and should be doable with a simple crosstab query.

If there were separate fields for each day of the week then that would be an issue.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]