Date and Day

[Brogrim]

I have a table called member attendance

MemberID, Number
Mon Boolean (Yes, No)
Tues Boolean (Yes, No)
Wed Boolean (Yes, No)
Thurs Boolean (Yes, No)
Fri Boolean (Yes, No)
Sat Boolean (Yes, No)
Sun Boolean (Yes, No)

I then print a report off by date, example Tuesday 1st August.

When I produce an attendance report I only want members marked in as attending on a Tuesday to appear on the list.

Am I correct in thinking it would be an if Statement

If the date is a Tuesday then only show records where the field Tues is = true

Any Ideas greatly appreciated

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Brogrim]

Thanks

can you be more specific or are you advising me to start learning database design.

thanks

 

[PHV]

Your member attendance table is NOT normalised ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

Where is the DATE in your table? Your design needs a bit of work as PHV has implied.

Skip,
[sub]
[red][/red]
[/sub]