Selecting opening hours on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want users to fill in opening hours on a form.

I planned four rows of multiple choice option buttons each row followed by
four text boxes with opening and closing hours (some establishments close and
reopen on the same day). Thus (sort of):

M T W T F S S From 00:00 To 00:00 From 00:00 To 00:00
O O O O O O O

Repeat (until all days are filled in)

Is this the way to go? Any other suggestions?

I may have to analyze the info at a later date when clients perform
searches. Therefore--Does Access have any special format for days of the week
as it does with times and dates?

Thank you

Peter
 
Peter, I suggest that you use a table with fields like this:
DayNum Number 1 for Sunday, 2 for Monday, ...
OpenTime Date/Time time they open on this day.
CloseTime Date/Time time they close on this day.

That structure will let you query anything, such as the number of hours open
each day, the total hours open for the week, the hours for any particular
day, and so on.

How you interface that is up to you, but I believe this structure in the
table will be you better results.
 
Thanks Allen

I thought that was the way to go, but wanted confirmation from an expert.

Thanks again

Peter
 
Back
Top