Search results

I hadn't considered that as an option, so thanks - however I think the previous solution is more flexible & less of a 'kludge'!!

Apologies, I can see how that's confusing. I'll have a play and get back to you if I need more help!

OK, thanks - there isn't a way to make it iterate through the different boxes & make a table for each?

OK, I think I'm getting there. I successfully ran your query, and got an output that looked correct, with columns for boxrow & boxcolumn. Then I ran the crosstab wizard on the query. It wanted to do a calculation at the intersections - whereas I just want the text. I chose 'first' as the...

My table just 4 columns - ID, tube name, box name, box position. Box position is a number between 1-100. For each Box name, I want to output a 10x10 grid, such that the tube names at positions 1-10 are in row 1, tube names for positions 11-20 are in row 2, 21-30 are in row 3 etc etc. I don't...

I can see how this would work, unfortunately the boxes are physically stamped with the numbers 1-100, so we really need to use the numbers to ID the positions. Would the cross-tab query work with just numbers? Also, in answer to your other reply - I do have the columns just as you described...

Hi, I'm a reasonably competent Excel user, but complete novice at access, so if I'm going about this completely wrong, please correct me. I want to track inventory. All our items are tubes that are stored in boxes in a 10x10 grid. So I have a single access table with columns for tube ID, box...