Combining relative information in feilds.

[Thomas Lewis]

I wish to combin similar feilds containg different information in Access 2003.

Example:

Name apples oranges grapes

John Smith, 5 apples, Blank, Blank

John Smith, Blank, 4 oranges, Blank

John Smith, Blank, Blank, 4 grapes

How would I combine these feilds to say:

John Smith, 5 apples, 4 oranges, 4 grapes

Thanks!

 

[akphidelt]

You can run a Totals query, and under the criteria of each of those fields
put in <>""

That will only work for this data, if you had any more info under apples it
would create a new line