Search results

  1. M

    Looking For Best Practice: Reoccuring data import and normalization

    Thanks for the replies. Perhaps I should clarify more: Most access tutorials/documentation I find focuses on designing an access database shell without data. The data would be input into the system by a user through forms, and reports could be pulled by other users after data has been...
  2. M

    Looking For Best Practice: Reoccuring data import and normalization

    Hi, I work with an employee database system that provides very generic reports. I would like to take 1 giant employee report and break it down into multiple tables to be imported into Access. I did this manually once to see if it was possible, and I pretty much used Excel's "remove duplicates"...
  3. M

    Lookups displaying AutoNumber instead of Field Name

    Thanks for the help! Problem solved. The article you referenced was quite helpful as well.
  4. M

    Quarterly Sales Commission Database

    I'm trying to create a database that can store client, employee and sales data. I also need to have the database calculate the quarterly commissions the sales employees have earned. However, the commissions are deferred over future quarters and I need the database to calculate future quarterly...
  5. M

    Lookups displaying AutoNumber instead of Field Name

    Hi, I just joined the forums and am hoping to get some advice on random issues I'm running into with my new database. I have 3 tables: [SurveyVendor], [Surveys] and [SurveyResults] SurveyVendor has 2 fields: [VendorID] - PK [VendorName] Surveys has 3 fields: [SurveyID] - PK [VendorName]...
Back
Top Bottom