IN Access XP, I have a query to bucket the revenues of various line item transactions which is working perfectly fine.
SELECT Revenue.ACCOUNT_NO, Revenue.INVOICE_NO,
bucket.[endvalue] FROM Revenue INNER JOIN Bucket ON
(bucket.[startvalue] and bucket.[endvalue]);
But when I copy the same query in other blank window query and run the query I get an error 'Missing ), ], or Item in query expression 'Revenue.TOTAL_INVOICE_AMOUNT between (bucket.[startvalue]'.