Maybe after my fifth cup of coffee I'll be awake. (not used to that nice
BOLD subject line either, I guess!) g

One way of doing this is to put the columns x and y in separate tables, and
then put the two tables in the same query, but don't join the tables.

for example...

SELECT tblA.x, tblB.y
FROM tblA, tblB;

this will return all combinations of values from tblA.x and tblB.y. So if
tblA has 3 records and tblB has 5, you'll end up with 15 records. So you
just turn the select query into an append query or make table query. Then
you'd have to update the prices somehow - either manually or with an update
query... depends if the price is a function of size...

--
Message posted via http://www.accessmonster.com