Data from a query and from a table on the same report.

[cpocpo]

Got the last few things of this database and it should be good-to-go.
This one has me stumped:

The "Employee" table has a column for "DentalDate" (4/26/2007) for
each person. This is the date of their last dental exam.

I set up a query which has two colums: DentalDate from the Employee
table and another column ("DentalDueDate") which gets its values using
the DateAdd formula (1 year from the date performed (4/26/2008)

OK, the "DentalDate" gets put in by the user, "DentalDateDue" gets
calculated during the query.


My question: I tried to put BOTH "DentalDate" and "DentalDueDate" on
the same report but it says that since I am pulling data from both a
query and a table, it won't work.

I even tried putting both things on a form and it gives me the same
error.

1) Can I use the dateadd formula to update a column in a table, or is
it just used for queries? (So everything is in the same "Employee"
table and maybe it will let me put them both (the date and due date)
in the same report.)

2) Is there a way to bring the calculations from a query and also the
data from a table and put them in the same report?


I am trying to show a list of all the recurring things (dental exam,
physical exams, etc.) for each person. The list would show the date
the thing was done and when it is due, but I can't seem to get these
two to come together.

Appreciate the help!

V/R

LostGuy

 

[Larry Daugherty]

Base your report on a query on the table. In the query, create a new
field - DentalDueDate: DateAdd......

HTH

 

[John W. Vinson]

1) Can I use the dateadd formula to update a column in a table, or is
it just used for queries? (So everything is in the same "Employee"
table and maybe it will let me put them both (the date and due date)
in the same report.)

2) Is there a way to bring the calculations from a query and also the
data from a table and put them in the same report?

Um?

Just do the calculation in a Query which includes all the fields that you want
from the table. You don't need a separate dedicated query just to calculate
one field.

John W. Vinson [MVP]