In need of Merge Help

[Pierre]

I have a table built with some information I would like to use on a new
table. The new table will be used for export use only and not for
information to be entered via a new form. But I would like to have it update
as information is updated to TABLE1. A detail of what is trying to be done
is:
TABL1 have fields called [Given Name], [Other ID], [Tax ID], and [Location]
TABLE2 have fields called [Entry Name], [ID INFO], and [State]
I need [Entry Name] = [Given Name]
[ID INFO] = [Other ID] &â€, “& [Tax ID] (w/ a comma space between if possible)
[State] = [Location]
Information from TABLE2 well be used in a Query then exported to Excel.

Note: Colum headers on Excel most READ field name from TABLE2. My reason
for making new table is to include some fields that will not be used, but
need to be displayed on excel sheet.

Any and all assistance in this matter will be greatly appreciated.

 

[Dennis]

Why not just create a QUERY that shows the fields you DO want, then export
the results of the query to you spreadsheet.

 

[Pierre]

From my understanding, I would need to change and add the header (top colum
information) to the excel spread sheet each time I export the few fields I
added to the Query.

Why not just create a QUERY that shows the fields you DO want, then export
the results of the query to you spreadsheet.

I have a table built with some information I would like to use on a new
table. The new table will be used for export use only and not for
information to be entered via a new form. But I would like to have it update
as information is updated to TABLE1. A detail of what is trying to be done
is:
TABL1 have fields called [Given Name], [Other ID], [Tax ID], and [Location]
TABLE2 have fields called [Entry Name], [ID INFO], and [State]
I need [Entry Name] = [Given Name]
[ID INFO] = [Other ID] &â€, “& [Tax ID] (w/ a comma space between if possible)
[State] = [Location]
Information from TABLE2 well be used in a Query then exported to Excel.

Note: Colum headers on Excel most READ field name from TABLE2. My reason
for making new table is to include some fields that will not be used, but
need to be displayed on excel sheet.

Any and all assistance in this matter will be greatly appreciated.

 

[Pierre]

TABLE2 has 20 fields and only 8 will be from TABLE1. The excel sheet will be
sent out for the reciever to add comments/info to the other (say) 12 fields
based on what I already have. Almost like a checklist that requires entries

Why not just create a QUERY that shows the fields you DO want, then export
the results of the query to you spreadsheet.

I have a table built with some information I would like to use on a new
table. The new table will be used for export use only and not for
information to be entered via a new form. But I would like to have it update
as information is updated to TABLE1. A detail of what is trying to be done
is:
TABL1 have fields called [Given Name], [Other ID], [Tax ID], and [Location]
TABLE2 have fields called [Entry Name], [ID INFO], and [State]
I need [Entry Name] = [Given Name]
[ID INFO] = [Other ID] &â€, “& [Tax ID] (w/ a comma space between if possible)
[State] = [Location]
Information from TABLE2 well be used in a Query then exported to Excel.

Note: Colum headers on Excel most READ field name from TABLE2. My reason
for making new table is to include some fields that will not be used, but
need to be displayed on excel sheet.

Any and all assistance in this matter will be greatly appreciated.

 

[Dennis]

Designing multiple (identical) tables is very poor design. As I said before,
you should simply write a query and export the results to a spreadsheet.
Although it may stretch your comfort zone, in the end you'll be FAR better
off...

TABLE2 has 20 fields and only 8 will be from TABLE1. The excel sheet will be
sent out for the reciever to add comments/info to the other (say) 12 fields
based on what I already have. Almost like a checklist that requires entries

Why not just create a QUERY that shows the fields you DO want, then export
the results of the query to you spreadsheet.

I have a table built with some information I would like to use on a new
table. The new table will be used for export use only and not for
information to be entered via a new form. But I would like to have it update
as information is updated to TABLE1. A detail of what is trying to be done
is:
TABL1 have fields called [Given Name], [Other ID], [Tax ID], and [Location]
TABLE2 have fields called [Entry Name], [ID INFO], and [State]
I need [Entry Name] = [Given Name]
[ID INFO] = [Other ID] &â€, “& [Tax ID] (w/ a comma space between if possible)
[State] = [Location]
Information from TABLE2 well be used in a Query then exported to Excel.

Note: Colum headers on Excel most READ field name from TABLE2. My reason
for making new table is to include some fields that will not be used, but
need to be displayed on excel sheet.

Any and all assistance in this matter will be greatly appreciated.

 

[Pierre]

I really apperciate your response and assistance in this matter. I will try
and see if the Query will allow me to add information from TABLE1 and change
the header as it displays on excel

Pierre

Designing multiple (identical) tables is very poor design. As I said before,
you should simply write a query and export the results to a spreadsheet.
Although it may stretch your comfort zone, in the end you'll be FAR better
off...

TABLE2 has 20 fields and only 8 will be from TABLE1. The excel sheet will be
sent out for the reciever to add comments/info to the other (say) 12 fields
based on what I already have. Almost like a checklist that requires entries

Why not just create a QUERY that shows the fields you DO want, then export
the results of the query to you spreadsheet.

:

I have a table built with some information I would like to use on a new
table. The new table will be used for export use only and not for
information to be entered via a new form. But I would like to have it update
as information is updated to TABLE1. A detail of what is trying to be done
is:
TABL1 have fields called [Given Name], [Other ID], [Tax ID], and [Location]
TABLE2 have fields called [Entry Name], [ID INFO], and [State]
I need [Entry Name] = [Given Name]
[ID INFO] = [Other ID] &â€, “& [Tax ID] (w/ a comma space between if possible)
[State] = [Location]
Information from TABLE2 well be used in a Query then exported to Excel.

Note: Colum headers on Excel most READ field name from TABLE2. My reason
for making new table is to include some fields that will not be used, but
need to be displayed on excel sheet.

Any and all assistance in this matter will be greatly appreciated.