link table to a query

[adgorn]

I have a table and a query. How can I design another query that will simply
attach each item in the table, in order from the first item on down, to each
item in the query. In other words, the table looks like this:
100
200
300
etc

The query output is this:
itema
itemb
itemc
etc.

I want another query to give me this:

100 itema
200 itemb
300 itemc
etc.
for all items in the original query.

Thanks.

 

[KARL DEWEY]

You can only link if they have common data. Here you do not have anything in
common in the two tables. Also it takes a least two fields, the second to
hold the common information.

 

[Michel Walsh]

Indeed.

A possible way to do it is to append the data into a temporary table WITH an
autonumber. That will make two temporary tables. Assuming the autonumber
start at 1 for each of the new tables, you can then use these autonumber
fields (there is only one per table) to join the two temporary tables, and
get what you want.


Vanderghast, Access MVP