Recent content by CrakD

It's not actually named any of those fields..i'm just using that as an example...It's actually a referral system..I didn't want to reveal to much...but...here's how it works...I need to be able to track referrals that nurses give the clinic. People call..they give basic information about the...

I have a db, in which there are several employees and on any given day they get an item abbreviation. Like this Date | Employee Name | Count| 06/1 | George | BEV | 06/2 | Chris | ICE | 06/3 | George | BEV | 06/4 | George | ICE | What I want is to be able...

It worked great...Thanks!

I have a query that has employees and it has multiple items that are associated with it.... There is an employee information table. for example: Equip_rent_ID Employee_Id(query) Liable Equipment 123456 Gutierrez, Chris Nextel Radio 123457 Gutierrez, Chris...

I have 2 Databases. A Referral Database, an Active Patient Database. How it works is..the patients are referred by doctors, therapists, etc. The information like date of birth, address, phone number etc. is input into the database. Then when the patient gets evaluated (up to SEVERAL weeks...

Well..here's the thing...it is a many to many. I do have it set up correctly. The problem comes into play when I want to run reports, using excel, since it's preferred by the boss. and I get this kind of thing Patient name Therapist Blow, joe Joe, nobody jane, mary palms, harry...

as it is right now....i run the census query and it gives me this: Field 1 Field 2 PATIENT THERAPIST Blow, Joe Smith, Angel Blow, Joe Holmes, Sherlock I really need it to be like this: Field 1 Field 2 Field 3 PATIENT THERAPIST...

I guess I had a brain fart. Thanks, I was making it much more difficult than it had to be. I appreciate your help. It's running smoothly thanks. Chris

I have added a "referral_ID" I can't believe I made that mistake. K, let me see if this can be explained better. nurse calls -> receptionist enters info in intranet page -> data is submitted to "referral.mdb". Then the day the patient is scheduled to come in and patient...

Hi, I'm co-oping in a pediatric rehab center. I am workin on an intranet page/database system. At this time I have 2 Db's, one ("referral_database")which get's it's info from a frontpage 2002 created db. The other db ("patient_db") which contains similar fields, like...