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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.