Combining duplicate output

[hairballx28]

Situation: [account information]2 tables. Need to query both to get desired output of account number, name and description. One table has the name and account id and description id. Another has the the description id and the description. The problem is that an acount can have mroe tan one descriton associaed with it. I need to be able to have only one record per account displayed wiht the description containt any possible description associated with the account.
Any help would be great. Thanks

 

[DougP]

Take a look at the "group by" function in the crosstab query

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[hairballx28]

I negelected tp metion I am a relatve novice as Access. I did not create a cross-table query. I do not need it to calclate a value i just needed it to combine the possible to text desciption. Can the cross table do that?