Merge Query Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not new to Access, but I am just getting into some of the more advanced
features.

I have a report based on a query that lists:

Job Name and Number
Lead Estimator
Bid Date
Bid Time

My problem is, I would like to merge 2 of the records together and only list
the unique data. For instance, right now my report looks like this:

Record #1 - Job Name: Anyplace HS HVAC Job #: 50000
Bid Date: 02/14/05 Bid Time: 3:00 PM
HVAC Lead Estimator: John Doe

Record #2 - Job Name: Anyplace HS Plumbing Job #: 50001
Bid Date: 02/14/05 Bid Time: 3:00 PM
Plumbing Lead Esimator: Jane Doe

Instead of listing each record separately, I would like the report to read:

Anyplace HS HVAC 50000
Anyplace HS Plumbing 50001
Bid Date: 02/14/05 3:00 PM
HVAC Lead Estimator: John Doe
Plumbing Lead Estimator: Jane Doe

I am not even sure if this is possible. Can anyone help?
 
What is it that ties these two together? They appear to have different
names, job numbers and estimators, so the only thing left is date & time.
Are you saying that you want any/all bids on the same date & time to be
associated?
 
Actually I didnt think about it that way before, but I guess that would work.
What would be the easiest way to do that. I have been looking at this too
long to see the easiest way I guess. Thanks!
 
Back
Top