Randomblink
The Irreverent Reverend
- Local time
- Today, 17:38
- Joined
- Jul 23, 2001
- Messages
- 279
Ok, I have ONE table that is being queried...
It has three IMPORTANT fields...
The table is based on projects...
Field#1) PROJECT #
Field#2) DRAWING
Field#3) PAGE
There are Projects with no Project entries.
There are Drawings with no Project entries.
What happens is...
I run the query, and I may get Project# 666 (he he) that has 30 different drawings, that are on two different pages. (ie 15 drawings per page). Or I may have 2 different drawings that are on 15 different pages (they are split up sometimes). Or I may have a list of drawings that have no project number!
What I want to do is...
Run the Query...
And have ONLY 1 of each Project list.
If there is no Project Number...
Then have ONLY 1 of each Drawing list...
Is this possible? Even telling me how to list ONLY 1 of each Project would save my sanity...thank you all...and to all a good night...it's 5pm where I am! ugh!
It has three IMPORTANT fields...
The table is based on projects...
Field#1) PROJECT #
Field#2) DRAWING
Field#3) PAGE
There are Projects with no Project entries.
There are Drawings with no Project entries.
What happens is...
I run the query, and I may get Project# 666 (he he) that has 30 different drawings, that are on two different pages. (ie 15 drawings per page). Or I may have 2 different drawings that are on 15 different pages (they are split up sometimes). Or I may have a list of drawings that have no project number!
What I want to do is...
Run the Query...
And have ONLY 1 of each Project list.
If there is no Project Number...
Then have ONLY 1 of each Drawing list...
Is this possible? Even telling me how to list ONLY 1 of each Project would save my sanity...thank you all...and to all a good night...it's 5pm where I am! ugh!