Info from two columns in a third

[capsula4]

Hi!

Say I have a table/qry:
ID | VARIETY | PRODUCT
1 | Fresh White | Garlic
2 | Fres Valencianita | Onion

Is therey a way to merge variety and product? Cause I want to make an invoice description with a text that can be made out merging fields of a same table/qry.

Sth like the following:
"[QUANTITY] of [VARIETY] [PRODUCT] from [COUNTRY], size: [SIZE]...."

I saw a topic about listing items horizontally but I think it was kinda different from what I wanted, specially cause involved more than one table.

 

[chergh]

SELECT [Quantity] & " of " & [Variety] & " " & [Product] & " from "  & [Country] & " size: " & [SIZE]
FROM table_name

 

[capsula4]

Thank you a lot chergh!!!