Is this Merge Possible ???

S

smboyd

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?
 

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

Similar Threads

Merge 2 query results into report 0
Merge Query Results 2
Is this the best design structure 1
Sum Job Time Column 6
Looking for formula 20
display each record only once 7
Macro for Copying pasting between different spreadsheets 4
Grouping - Distinct 5

Top