Recent content by sara82

JoeCruse: The User Main Menu, does not have a record source it just hold the 4 command buttons. The WorkLog Form's record source is a table, tblWorkLog. Can I still do this even though the Worklog's form's record source is a table?

I have a User Main Menu as seen below with the command buttons for New Work Log Entry and Edit Work Log Entry. The New Work Log entry opens a blank Work Log as shown below. The Work Log form's record source is tblWorkLog. The user will fill out all the fields except the End Page and Total Worked...

Quick question, if I entered the Start Date as 11/1/05 and I left the End Date blank shouldn't it return results starting at 11/1/05 to present? At the moment if I do that (leave the End Date as blank) it returns all records even those before 11/1/05.

I think I may have solved the problem. I'm still testing it out to make sure. The Log Date was storing both the Date and Time. LogDate is being populated by (Now) in the form's Before Insert Event. I had: Me.LogDate = (Now) I changed it to Me.LogDate = Format(Now, "mmm d yyyy") So that...

I am having trouble with the query producing the correct Dates. I have the Log Date Field and for the criteria I have: Between Nz([Forms]![frmDate]![txtStart],[LogDate]) And Nz([Forms]![frmDate]![txtEnd],[LogDate]) When I run the query it asks for Forms!FrmDate!txtStart I enter 10/1/05 It...

mech55 Can you please tell me what you did? I have the same problem. With me I added it to the parameters and also to the Date field but it is not filtering out to the correct dates. For instance when the parameter comes up for StartDate I enter 10/1/05 and parameter for EndDate I enter...

For anyone following through I was advised to do the following and it works (excludes the two 15 minute breaks) [LogHours] = Round((DateDiff("n", [Starttime], [Endtime]) / 60), 3) + (([StartTime] <= #09:45:00 AM# And [EndTime] >= #10:00:00 AM#) / 4) + (([StartTime] <= #02:45:00 PM# And...

Pat, As I mentioned for me to get this working I did the following: [LogHours] = Round((DateDiff("n", [Starttime], [Endtime]) / 60), 3) I have come across a problem. There are two 15 minute breaks throughout the day. One at 9:45 AM to 10:00 AM and one at 2:45 PM to 3:00 PM. What can I do...

Below is a visual picture of what's going on: Two crosstab Queries one that calcuates the Sum of Total Hours employees worked for each Job Type and the other calculates Sum of the Total Pages worked for each Job Type Then I have a select query that inclueds both the Sum of Total Hours and Some...

Rich, Sorry I'm not getting this right way, but where do I sent the parameters to Date/Time in the crosstab query? I have a select query which has fields from 2 Cross Tab Queries. These queries find sums of hours and total pages employees have worked on. I have the field "Log Date" but if I...

The query I have is a Select query but it has some fields that are based on a crosstab query so I am guessing that may have something to do with the problem?

Rovers, I tried your suggested but I get the same error message. [forms]![frmDate].[txtStart]' as a valid field name or expression.

I have a report that once clicked a form comes up to choose the dates one would like to filter by. It has a Start Date and End Date. After the user picks the Start Date and End Date the report will be shown for those dates. The record source for this report is a query I wanted to use this...

I implemented this: [LogHours] = Round((DateDiff("n", [Starttime], [Endtime]) / 60), 3) And from the table design view had to format loghours field to text, and everything is calculating correctly now.

I have tried: [LogHours] = Hour(TimeValue([Endtime]) - TimeValue([Starttime])) + ((Minute(TimeValue([Endtime]) - TimeValue([Starttime]))) / 60) [LogHours] = DatePart("h", [Starttime] - 1 - [Endtime]) + DatePart("n", [Starttime] - 1 - [Endtime]) / 60 [LogHours] = ([Endtime] - [Starttime]) * 24...