we have a table which was created from a number of text files containing data relating to names and addresses. We need to use the names and addresses for a mail merge. The problem is there are 4 records relating to each property each with a common property reference field The 4 records have a field which denotes either Dw for dwelling address, Oc for occupiers name, Ow for Owners name (which may include an address and Ag for Agents name and address We want to produce 1 letter for the occupier combining the name from the oc record and the address from the dw record (the link being the property reference) and 1 for either the owner if there is no agent or the agent if there is one (these are 2 separate records) Also we need to exclude duplicate entries for agents so that only 1 letter goes to 1 agent even if they have entries beside several property references.
Any clues guys as to how to create the necessary queries?
I'd be really grateful my boss needs this kinda yesterday
Any clues guys as to how to create the necessary queries?
I'd be really grateful my boss needs this kinda yesterday