Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating time reports

Status
Not open for further replies.

acarr2032

Programmer
Oct 4, 2004
18
0
0
US
I have created a report that feeds off of a query and a date form, basically a user types in the date in a date form that triggers a report to shoot off with the appropriate info for that day. The problem that I have come across is that the users also want to break the report down into 3 sections to represent the shift times, Morning=5am to 12pm, Afternoon=12:01pm to 5pm, Evening=5:01pm to 4:59am. I thought about using option buttons on this but I think that might be more complicated. As it stands I have to put the user in this also to further break it down.

Date______
User______

Shift
Morning___
Afternoon___
Evening___

Exit OK

I am pulling from a query that has all the correct info, date, time, etc...

Is there an easy way to make this happen?




 
Nevermind, took sometime but I figured it out myself.
THANKS!
:p
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top