Copy data from one field to several fields

[Patsar]

Hello All !!! I am a photographer trying to automate my processes using Access. I ran into an issue that I am not able to solve alone. Your help would be very much appreciated.

I have the following tables:



Clients : [ClientID], [Name], [Phone], [Email]
Proof: [ProofID], [ClientID], [Proofs]

There are 4 proofs for each client. To automate the printing of my order forms. I need to merge and export the data into an Excel spreadsheet with the following fields:

ClientID, Name, Proof1, Proof2, Proof3, Proof4

How can I copy the [Proof] entries to different fields ?

Thanks a lot !!!

[June7]

This is de-normalizing data.

One method is a CROSSTAB query. This requires a field that numbers the four records. This field will be the column header in the CROSSTAB.

Another uses VBA to write records to a 'temp' table (table is permanent, records are temporary).

Why do you need Excel involved? Why not Access report for printing documents?

[Patsar]

Thanks a lot, it is the solution to my problems but is there a way to easily populate de the field that numbers the four records? I have more than 600 proofs to numbered !!!

You are right I probably can avoid using Excel... I need to export a .CVS file to use with Adobe InDesign to create my order form. Thanks a lot you just save me a lot of work... by the way this issue arise from bad database design (photographer acting as database programer !!!)... I changed my design for my next client but I need to save the data fot this client !!!

[June7]

Not sure it is 'bad' db design, but definitely a special requirement for data output.