Search results

  1. A

    Add two fields to a query

    I have this query: SELECT A.*, AppointmentCost - Nz((SELECT SUM(PaymentAmount) FROM tblPayment P WHERE A.AppointmentId = P.AppointmentId),0) AS AppBalance, Date()-AppointmentDate AS DaysOutstanding FROM tblAppointment AS A; When I run it shows: AppointmentID PaymentID AppointmentCost...
  2. A

    Need a opinion on structure

    I have three tables tblpatient, tblContacts, and tbltelephone. They are structured like this: tblpatient tblcontact tbltelephone patientID PK contactID PK phoneID PK patient account number PatientID FK...
  3. A

    Relationship and referential integrity

    Being as how I'm new in using Access I need some guidance. I have three tables I've set up my relationships as follows: tblPatient tblContact tblPhone PatientID PK ContactID PK PhoneID PK PatientAccount FK PatientID FK...
  4. A

    field names

    I need an opinion. I'm new to access so I'm really lost I have to create a database consisting of 20 clients. Then they gave me 4 steps I had to accomplish: Create a total of all account balances, so the total number of recievables are known. For each account, calculate the number of days each...
  5. A

    DateDiff in a query

    Have a table which has 4 fields PatientID FirstName,LastName,BalanceDue,Due Date Trying to create a query that will show all fields of the accounts that have due dates that are under 30 days. I tried this Under30: DateDiff("d",[DueDate].Now())criteria >0 And <30. But can't put anything in the...
  6. A

    calculating date

    I'm suppose to create a list of 20 clients and let 5 accounts be 90 days past due, 5 over 60 days, 5 over 30 days three of each of the accounts have a balance over $75. Then it asks me to create a total of all account balances so that the total amount of recievables can be known. The second part...
Back
Top Bottom