Merging information from two fields in Access 07

[rw8316]

Hi,
I'm trying to find a way of merging two fields into one for a report in Access 07.

So, I have two columns in a table called "referral date" and "reassessment date". In the report, I need the two to merge so that the "reassessment date" and "referral date" appear as one list of dates sorted by most recent first.

I'm very, very, new to this, so any help would be appreciated...

[jimatqsi]

You're going to want to use a union query for your report source. Here's a simplified example:

Select [Referrer date] as dateColumn from SomeTable 
union all
Select [Reassessment Date] as dateColumn from SomeTable
 

The 'all' tells the union query not to group similar results.


Jim

[rw8316]

Thanks Jim, another part of the puzzle sorted!