Append Query - Need Help!

  • Thread starter Thread starter Fred Worthington
  • Start date Start date
F

Fred Worthington

Greetings:

I am trying to use an Append Query to combine the Names and Addresses from
the ContactInformation table with Training Sessions and Dates from the
ClientTraining Table into a single table (PostCardTable) that I can use to
merge data in a Publisher document.

Here is my problem:
The Training Session Field uses a query as the row source. The query is
used to sort Training Sessions from the Training Table alphabetically in the
drop-down list of the form field. Even though the Training Sessions appear
by name in the ClientTraining Table, when I run my Append Query to the
PostCardTable only the Training ID appears. If the Training Session does
not appear by name in the PostCardTable, I cannot post it in my reminder
card. A little sage advice would be greatly appreciated.

Thanks . . . Fred
 
Greetings:

I am trying to use an Append Query to combine the Names and Addresses from
the ContactInformation table with Training Sessions and Dates from the
ClientTraining Table into a single table (PostCardTable) that I can use to
merge data in a Publisher document.

Here is my problem:
The Training Session Field uses a query as the row source. The query is
used to sort Training Sessions from the Training Table alphabetically in the
drop-down list of the form field. Even though the Training Sessions appear
by name in the ClientTraining Table, when I run my Append Query to the
PostCardTable only the Training ID appears. If the Training Session does
not appear by name in the PostCardTable, I cannot post it in my reminder
card. A little sage advice would be greatly appreciated.

Thanks . . . Fred
Click to expand...

Two suggestions:

It's just as easy to Export a Query as it is to export a Table (to
*most* programs - I'm not absolutely certain about Publisher). And you
avoid all the bloat and overhead of running a MakeTable or Append
query storing data redundantly.

Secondly, you appear to be yet another victim of Microsoft's
misleading Lookup feature. Your ClientTraining table APPEARS to have a
name in it - BUT IT DOESN'T. It has an ID, which is concealed from
your view by this misdesigned and all but useless wizard!

You will need to create a Query joining the ClientTraining table to
the Training Session table, joining by the sessionID; select the
session name from the table where that name actually exists. And get
rid of your Lookups, and use Forms to enter data rather than table
datasheets!
 
Thanks, John! That did the trick. I have Publisher 2000, and it doesn't
appear to offer the option of merging data from a Query. But, thanks to
you, my table is working just fine now.

Fred
 
Back
Top