This one has totally stumped me, I have Locations down a certain Aisle (JY) and im counting the number of pallets as below.
Code:
=DCount("Customer","qryTableMerge","Customer='WRIGLEY' AND Location LIKE 'JY*'")
The locations go from JY025A to JY138F but I need to count the number of pallets from JY025A to JY084F and a separate label will count from JY085A to JY138F.
So I need the LIKE Value to pickup the JY Aisle and then <> the values above (Hope I explained that well)
For the life of me I cant think of the best way!!!