Search results

We have an existing database that pulls a number of its tables from links to Excel worksheets that are updated each night. In one query, I have a field that shows and Employee ID and that links to a table with ID #s and the employee's name. The problem is that some cases we have are not...

I inherited some databases in a new job and need to get a full understanding of the tables, queries, reports, macros, etc. Someone in our office said they knew of a potential software program that would "map" your Dbase information for you. Is anyone aware of such a product?

Okay! I have tried all day to come up with the answer to my dilemma and simply have hit my capacity. I am sure this will be a cake walk for someone out there. I have a table with status field indicating whether the person covered has Single (S), Family (F), etc. coverage. There is another...

I have searched past questions and could not find any answers to the following. When we imported data from another Dbase (not Access) into our Access DB, the date field came out "yyyymmdd". I have added "0000/00/00" to the input mask which provides it the necessary "/". However, I really need...

I am printing a report that is combining 20,000 (eventually 60,000) employees with over 1200 health plan options, 250 dental plan options, and two other sub-reports. I did the print preview when I left @ 4pm yesterday and it was up this morning. Therefore, I am unsure how long it is taking to...

I am creating a report where a print out will show a list of data being sent to each location. Each location has anywhere from 2 to 10 different forms they could receive. WHEN a certain form is sent, it needs to have an "X" mark in a corresponding field showing it was included in the packet...

Thanks to anyone who can provide an answer to this fairly simple question. I am building a form for insurance enrollment that pulls data from 3 queries. In the original design of the form with the Wizard, I selected the fields I needed from each query. HOWEVER, now I need to add another field...

Again, something that stumps me but should be easy for many of you. I have a Health Benefits Dbase where we are importing data from three seperate systems into Access. The information we are getting from benefits specifies either "PPO Basic" or "PPO Plus" for a number of the plans available...

Group- I am wet behind the ears with Access programming language and need some help on the IIf function. I have a field for Medical and Dental coverage with either an "A" or "G" for Covered or an "I" or "W" for Not Covered. What I want is to create a way to have the words "Covered" or "Not...