Search results

After a few days of hitting my against the wall, I could really use some help. I have a pretty basic DB - 4 tables Orders Customers Order Details Products Products are assigned to specific customers. I have built a form with a subform. The Master Form contains ServiceID and CustomerID...

:banghead:I think I am brain dead right now and could use a little CPR to help me out! I have a DB with 4 tables: Property (used for look-up values) Service Type (used for look-up values) Rate Table (uses the Property Table and Service Type Table and is used as a rate look-up table for the...

I have a report that has multiple fields - 3 of which matter for this discussion - 1.) employee 2.) employer 3.) rateofpay The employer field contains 1 of 2 options. For the sake of this conversation, lets call it ABC123 and XYZ123 I need to be able to calculate the average rate of pay...

I have a dbase with payroll data for a 31 day period. Each day (1 to 31) is a field in a record and is named as Day1, Day2, Day3 and so on. I have designed a Query that presents each days data, and sums on a MTD basis. I am forced to design my records using this format as I am importing data...

Could use a quick response on this one ... I have an Employee Records table with 29k records that I originally imported from an HRIS system. Lets call this table ORIGINAL table. Each week I export a new Employee Records table from the HRIS system as it contains the latest updated...

Access 2013 I am trying to add some numbers together for a number of fields, of which at least one field will either be 0 or empty. I am trying to use the following formula in a calculated field in a table: IIf(IsNull([Price Increase %]),[Total],([Total]*[Price Increase...

Good Morning I have a continuous sub form linked to a master form. The sub form contains fields such as [date], [increase], [lastdateincrease], [task], and multiple other fields. The sub form can have one record or multiple records linked to the master form. Each sub form record represents...

I have a subform that is continuous and linked to the master. The form contains a number of fields to calculate hours spent on a project. The fields I have are: StartTime - date/time field, short time EndTime - date/time field, short time HoursWorked - calculated field = [EndTime]-[StartTime]...

Could use some quick help ... have 2 tables / 2 forms table 1 - Calendar ID field Date field - imported 3 years of dates Zone field - drop down look up to Zone Table mutiple other fields table 2 - Production ID field Date field - down down look up to Date field in the Calendar table...