report?

[NomoreSpam4Me]

Hi , i have a problem, i dont know how achieve what i want to do.

I have 3 tbl.

tblRepair
tblNotice
tblFinal

Each of the tbl have a date on it. And they r all link with an ID
field.

So i have a date when i send a Repair, a date when i receive a notice
and a date on the Final(when the repair has been made)

what i want to do is to be able to see wich items r still in repair
(they only have a repair date),and i dont know how to build my report
to achieve it. I would like to see wich item have receive a notice on
another report.

i know a bit of VBA if it can help.
I did a qur with the ID , and tblRepair.date,
tblNotice.date,tblFinal.date.

now i'm a little confuse about how to do this.

any1 can help??

thx

[Salad]

No***********@hotmail.com wrote:

Hi , i have a problem, i dont know how achieve what i want to do.

I have 3 tbl.

tblRepair
tblNotice
tblFinal

Each of the tbl have a date on it. And they r all link with an ID
field.

So i have a date when i send a Repair, a date when i receive a notice
and a date on the Final(when the repair has been made)

what i want to do is to be able to see wich items r still in repair
(they only have a repair date),and i dont know how to build my report
to achieve it. I would like to see wich item have receive a notice on
another report.

i know a bit of VBA if it can help.
I did a qur with the ID , and tblRepair.date,
tblNotice.date,tblFinal.date.

now i'm a little confuse about how to do this.

any1 can help??

thx

You can create a query. Let's say you have Table1 (main) and Table2
(linked). You drag a relationship line between the link fields from
table1 to table2. Then dbl-click on the line. You can then change the
type. Change it to All Records in table1 and only those that match in
Table2. Drag the date field down to table2. Now when you run the
query, you can enter Is Null in the criteria field for table2's date field.

[NomoreSpam4Me]

i was missing the Is Null part. thx, i should be able to do something
with that.