Search results

Cronk ... thanks! I figured that out and gave up on the table. Sometimes I just can't get my brain out of Excel mode and into Access mode! I did end up creating the forms and was able to limit the combo box, now having issues with updating the combo box using After Update. Would you mind looking...

Mihail - Thank you for your comments. I was brain dead last night and thought that I might be able to take a short cut in my posting. Obviously it was the end of the day ... attached is the database design. I hope this helps as I need to move on from this challenge.

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

ypma - Thanks for your response. I tried this previously - unfortunately it averages over all records. I should have indicated that I need to average over subsets of records that are grouped by invoice number in my report. Anyone else can weigh in? I ended up doing a work around by creating...

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

Thanks all - problem solved - hadn't considered the Append Query to normalize the cross-tab import of data. Much easier and a whole less troublesome as I work through the creation of the dbase.

Thanks All! Hadn't thought of the Append Query to normalize the data - hadn't never been faced with the issue of importing cross-tab data - thanks for the help!

Normalize the data after import ... OK - agreed. So now assuming I am importing the file as described - each line consisting of EE information, plus 31 days of data fields per record, how do you best normalize this in Access?

WOW ... that wasn't a ton of help! But did get me thinking ... Lets try this again - each record contains EE Name, Position Worked, and 31 Days of data as Day1, Day2, Day3, Day4 ... and so on. This data come from a separate Time and Attendance system that I can't extract in a list format...

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

Thanks Dave - no sub report. This is a sub form with linked master and child. I am updating on the fly and rather than having to enter the price % increase and date of increase for each record in the subform, I'd like to enter into the first record and update the remaining records in the...

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