2 detail sections on a report?

  • Thread starter Slez via AccessMonster.com
  • Start date
S

Slez via AccessMonster.com

I'm posting this with this question in mind: Is what I'm trying to do even
possible?
(I know that may drive some programmers nuts, but I have to start there!)

I have the following table structure:
tblProject has fields ProjectID & ProjectName (One side of One-to-Many
relationships)
tblBid has fields BidNumber, BidType, Estimator, etc. (on "many" side of
relationship with tblProject)
tblProjectClient has fields GCName & GCContact (also on "many" side of
relationship with tblProject)
So both tblBid & tblProjectClient are on the same "level" of relationship
with tblProject.

Ultimately, I want to create a report that, under each Project, shows the
list of BidNumber and GCName records, but because these are on that same
"level", I'm in a situation where I have to list one or the other. The query
that my report is based on returns a GCName for each BidNumber so it looks
something like this:
BidNumber 1 GCName A
BidNumber 1 GCName B
BidNumber 1 GCName C
BidNumber 2 GCName A
BidNumber 2 GCName B
BidNumber 2 GCName C
BidNumber 3 GCName A
BidNumber 3 GCName B
BidNumber 3 GCName C
...and so on...

Ideally, I'd like to convert the records in GCName into a string or something
and list them in the ProjectName Header.

I hope this make sense. Are there any suggestions out there on if this is
possible or how I can accomplish this?
Any feedback is appreciated!
Slez
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top