First Tony said, "Re: Query Problem: ACCESS 95" to Bryan, but then...
 TT> Yes, you do need the crop table.  Or you should.  Or at least it will
 TT> save a lot of time and ensure valid data.
Then use it as a lookup table, but it has nothing to do with
formatting your report as you requested.
 BH> Set up a report with the following:
 TT> Good solution but, as per my other response, what happens if the
 TT> grower has more than 5 crops?  Like 20 or 40.
Well, you can either expand the number of IIF lines to include
your maximum number of crops, or if the number is large (and you
don't know how large), then you'll have to write a procedure.
... I remember when Saturns were rockets, not cars.
--- Blue Wave/Max v2.30 [NR]
---------------