Search results

Not sure what else to give. The Form [Forms]![frmTimeClockEntries-SelectedForReporting-Parameters] has a Combobox as it's first field. The name of that combobox is [cboSelectedEmployee] Then it has a StartDate and EndDate field. I have a Select Query named...

In my Parameter selquery [Forms]![frmTimeClockEntries-SelectedForReporting-Parameters]![cboSelectedEmployee]

SELECT [qry_Employees].[EmployeeID], [qry_Employees].[PRSystemEmpID], [qry_Employees].[EmpFullNickname], [qry_Employees].[EmpFullName] FROM qry_Employees;

Hey thanks.... It was a sample data issue and field Default value issue. After I downloaded your sample db and saw that it worked, I went back to mine and it still wouldn't display anything but the value 2. So I then went into my table and on the surface at least it looked right. However...

Hello again and thanks in advance to any responses. On a Form I am attempting to use a Time field "StartTime" and perform the following IIf( (Between And)) in an Unbound txtbox =IIf(([StartTime] Between #10:00:00 AM# And #11:59:00 AM#),1,2) Regardless of any time values I insert into the...

After reading multiple threads here I have built a Form for the user to select and/or enter their parameters that they want used within a Report. The Form includes 3 fields One a combobox to select the Employee and then 2 text boxes to select BeginDate and EndDate My select query works well to...

No. The report will list the customer, the starttime, the endtime and the alias time field. However when I go to the section footer the only option in totals is Count. Sum avg etc... Are disabled. In my test data one proj had two line items of 4:40 each. So it wouldn't be a > 24 hr issue.

I have a table of Time records, tblProjTime. PKID, CustomerID (lookup to tblCustomers), with three additional fields, a) Completed (Y/N); b) StartDateTimeStamp (General Date = Now(), c) EndDateTimeStamp (General Date = Now() when completed) I have a form with queries that upon project...

Poppa Smurf Thank you! I modified it for my purposes.

Hello again from a Newbie trying to "survive" long enough to be a novice. I have a db for Equipment rentals where in Rental Rates are based first upon Days then partial days are billed based upon hours and minutes. ************************************************** I have created the following...

WayneRyan Thank you for responding! I fiddled with it and finally after hours figured that out about 30 minutes before you posted the response. Wish you had been around sooner! Just for my educational purposes. Based upon the above description, do you see a better way of accomplishing what...

I'm relatively new at Access. I previously posted a tread regarding Tips and am going about it in a different way now. ******************************************************* Background First, I know everyone never reports all their tips. That part isn't MY problem. I am trying to create a...

PS, FWIW I don't think ANY of them report them all. But we will have gone beyond the norm to try to get their info so they can't say much of anything to us. Just trying to stay a 1/2 step ahead of those guys if you know what I mean.

**************************************** Here They are, And below is the SQL Coding But it is also in a jpg attached SELECT tblActualTipsReported.ActualTipsReportedID, tblActualTipsReported.EmployeeID, tblActualTipsReported.DateTimeStamp, tblActualTipsReported.TipDate...

I am creating a portion of a db wherein Employees input their day's tips. According to IRS rules, shared tips are to be documented. Thus I have created a Second table for Shared Tips. *************************************************** A) The Main table = tblActualTipsReported has the...

JANR Your solution worked perfectly!!!! Thank You again. One observation. I had to add a Select Query so I could calc the "Business Day" based upon the transaction's time and date as it compared to the "default Business Start Time". Thank you again

Thanks so much! I will give that a try. Embarrassing how one misread word (make a table vs make table query) instruction can change the meaning so much.

As with many others that posted similar threads on this topic, I am new to Access AND to VBA coding so what seem as simple answers or instructions by experienced users zoom right over my head. That said I am creating a db for my Company. I've viewed training videos and purchased a more in...