Entering data into the proper day

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I have a report that I'm trying to duplicate a governement form on and it
MUST come out just like they want. It is a Time Entry sheet that makes you
put the data into the proper day of the week. I need it to report in a box
on the proper day. The report looks like this:

Mon In Out Tue In Out Wed In Out
etc....................
--------------------------------------------------------------------------------------
8:00 12:00 8:30 1:30 2:00 4:30
etc.................
12:30 4:30

The data is entered into the table by date. Each record has an in and out
time. How do I get the data to decide what day it is and put it in the
proper box? Can I have the report put multiple days on the same line; i.e.
Mon Tue Wed, and can I have it start a new line if the day already has a
record reporting like the example?

Did I explain it right?

Bruce Rodtnick
 
I checked out the Calender Report database and it did not have what I was
looking for.

I have a group of text boxes that I want the database to put the data into
the right box based on the day of the week. In other words if this day is
Monday, I want to put in the hourIn on one Box and HourOut in another box
and so on for the whole week. I found vbDayOfTheWeek, etc. and that looks
promising but I don't know where to put it.

Bruce
 
There are other sample reports that place text boxes in columns based on
dates. I would go with any one of the solutions and possibly abandon your
"group of text boxes".
 
Back
Top