Search results

Thanks! It worked! I can't believe I forgot that structural design element. Thanks for the reminder.

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?

Thanks Everyone. I went a simpler direction and created a key to connect the people with their plans as we had done the first round. We were trying to link plans with people by three seperate fields and it was getting to be too much for me to learn how to program. Thanks! I will use this in...

Thanks...but? Thanks. I figured that was what I was supposed to be using. Here is what I came up with though: Select Case [Benefits]![EE Covg] Case "S" [Benefits]![Med Mon Rate]= [Medical Rates]![EE] Case "F" [Benefits]![Med Mon Rate]= [Medical Rates]![Fam] Case "1" [Benefits]![Med Mon...

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

THANKS! I don't care that it's CLUMSY, it WORKED! Thanks a bunch. Brandon

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

It worked! It worked....thanks! Brandon

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

YEAH! THANK YOU TO EVERYONE WHO HELPED! I finally think I am beginning to get a better understanding of this program. I ran it all into one query and then built the report off that. It's great. Thanks Pat and Sohaila. Brandon

Got it...but still one more question Sohaila- You are helping me SO MUCH. Thanks! I saw how adding a field into the query adds the field into the form or report. HOWEVER, my problem is that I never based my report SOLELY on one query or table. Rather, I pulled assorted fields that I needed...

Thanks...question though I can see how this works in a form. However, can you do the same thing for a report? If yes, how so? Brandon

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

Thanks Had tried another way, but your way is much better. Thanks! Brandon

Figured it out! Pat- Sorry about the bother, but I figured it out. I am SO THANKFUL for this forum and all the help it has given me. Kudos and keep up the good work! Brandon

Making progress..but one question Pat- Thanks for the help on this. I was able to create the BCBS addition to the records through the Update Query. In creating my Append Query to add the UHC plans, I have run into a problem. I have selected all the rows and they will append to the same...

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

It worked! Thank you so much! It worked beautifully. Brandon