I have three tables tblPatient(whic h contains patient info) tblContacts (which contain names to contact in an emergency) and tbltelephone (which holds phone numbers for patients and contacts. I need to create a query that gets patient first name, patient last name, and just patient phone numbers.
My tbltelephone is set up like this
phoneID PK
PateintID FK
ConatctID FK
Is the above mentioned query...
augie0216
Last Activity: Nov 27 '06, 06:11 AM
Joined: Jul 11 '06
Location:
-
Is This query possible?
-
Can't get fields to populate
If you doing a query on a table with these fields ClientID, FirstName,LastN ame, and Balance. If you sum the balance. Is the a way to also see the other fields along with the balance. -
DateDiff in query
I have a table with 5 Fields PatientID,First Name,LastName,B alanceDue and,DueDate.I want to create a query that shows 4 catagories under 30,over 30,over 60,over 90 of balances due . I've tried using this as a sixth field as a test
field name under 30: DateDiff("d", [DueDate] ,Now()).Criteri a >0 and<30. But when the parameter dialog pops up and I enter 30 and click ok the field headings show up but no data is present. I would... -
Sort by date
This is the the first time using access so I'm a bit confused. I created a simple table with these fields: last name,first name,last appointment, and due date. This database will be used to inform patients they are due for checkup. I sorted the table alphabetically by last name. I would like to create a query that sorts the due date column. by the group with the next due date. in other words assume this is April and I want to have all the May appointments...
No activity results to display