Thanks for the help! I actually was looking to use an array because I can reference cells out of order a lot easier that way (for instance, I might need to reference the first three from rstToP and then get the first in the list from rstToHS, go back and get the fourth from rstToP and then get the first two from rstToF), but I think I'm just going to stick with using four recordsets and using MoveNext to go through them, since I'll only ever have...

They are from four separate queries, but I need them to be lined up abreast, rather than "end-to-end" like a UNION would.

ie:

item1 loc1 item2 loc2 item3 loc3

not

item1 loc1
item2 loc2
item3 loc3


I'm mainly wondering if there is a simple way to add them to the recordset while forcing which rows they each go into. I know if you use varToArray = rstToP.GetRows( 9999),...

I have four recordsets (rstToP, rstToHP, rstToHS, rstToF) each with three columns (Item, Location, Type). I've used code like

to help me count the records and make sure I have the array dimensioned properly. Now...

I'm having trouble getting this query worked out. In my table, the relevant fields (with descriptions) are:
SKU(the Item Number), StorageType (the type of rack the item is stored in, IE: pallet, half-pallet), Location (obvious), QuantityPicked (obvious), Area ('Front' or 'Back' of the warehouse)

What I need to do is find instances where the QuantityPicked is 0 and the Location is Front (meaning the item is sitting near the...