combine records into one row

[hobbes]

Hi,
I have multiple queries that end up producing a table with records that I want in a single row, but are currently in two rows. Here is an example of the table results:

Account Number Name US Foreign
1234567 ABC Co. 125
1234567 ABC Co. 500

How do I combine the records to get the following result?

Account Number Name US Foreign
1234567 ABC Co. 125 500

I thought I saw at some point a thread that discussed this, but I couldn't find it.
Thanks in advance!
Hobbes