Susan I'm not sure of the structure of your database. However, if the table contains VAT code, amount paid and date you can simply use the report to group the payments quarterly. In the report's underlying query you'd filter the records that match VAT only. You may have to do the grouping in the report and not in the query.
A clearer explanation of your problem may lead the group members in the right direction to assist you better. Regards Liveson ----- Original Message ----- From: "Susan Johnson" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, 07 April, 2006 14:29 Subject: [ms_access] Create a query/quarterly/summarize Hi all, I am trying to create a query (to create a report) to summarize the VAT paid by the company per quarter. I did this for the sales database, I thought by simply using the query wizard (I am NOT an Access whiz..!) but I cannot make it work with the Purchases database. Can someone steer me in the right direction? Thanks Brgds Susan [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
