combine multiple fields into a query (1 Viewer)

nobby

Nobby
Local time
Today, 11:34
Joined
Dec 28, 2008
Messages
24
Hi All
I have had a reply from MAJP and others which really helped
I am doing a family tree and trying to make a timeline so It will be a persons birth date and then christened date and marriage date and date of death for both partners

I currently have 8 append queries to do the job but im thinking there must be an easier way
MAjP suggested a really good way but I couldn't get my head around the syntax

I attach the cut down database if anyone wants to suggest the SQL syntax I should use
 

Attachments

  • temp.zip
    61.6 KB · Views: 70

isladogs

MVP / VIP
Local time
Today, 11:34
Joined
Jan 14, 2017
Messages
18,207
Suggest you provide the link to the previous thread and MajP's solution
 

Users who are viewing this thread

Top Bottom