By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

report?

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
i was missing the Is Null part. thx, i should be able to do something
with that.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.