Search results

  1. M

    IIf Between And and Time fields

    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...
  2. M

    Parameter Form to build report - Requery if Null Nz

    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...
  3. M

    Sum Time - Report uses Query Alias result

    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...
  4. M

    Elapsed Hours and Minutes

    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...
  5. M

    Query of 2 related Queries

    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...
  6. M

    Display total of a subforms entries on Main From - Query for Subforms Total

    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...
  7. M

    Struggling with Update Query

    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...
Back
Top Bottom