Recent content by ABP
-
A
Convert Access 2002 Pivottable to Query?
At present it appears as an alternative way of viewing the table. I wish I could just right click it and be able to view the SQL which generates the data then copy it into a fresh query. -
A
Convert Access 2002 Pivottable to Query?
Is it possible to convert an Access 2002 pivot table into a query? -
A
Count "Enquiries" per hour / day / date over a period of time
Thanks for you response Namlian this has really helped. I now need to work out how to make it so I can make the query extract the "hour" data from the timestamp and count the number of enquiries in that hour over the month displaying it as above. I have a feeling that I need to use the... -
A
Count "Enquiries" per hour / day / date over a period of time
*bump* (Apologies) -
A
Count "Enquiries" per hour / day / date over a period of time
I'm currently working on an access 2002 database to replace a spreadsheet which has reached critical mass. I have a table structured as follows:- tbl_enquiries ID (Autonumber) Success / Failure (Text) Timestamp (Date/Time - General Date) Responder ID (Text) Policy Number (Text) SIB (Text)...