Search results

Ok, Thanks for the help. I've got the stage where I've created a crosstab query but it is not relevent to the date fields I have on the form and is just adding all the items from every Jan together etc. What expression do I put in the column heading field? The values for the dates are...

Hi all, I'm a little stuck with what seems to be (to me anyway) quite a complicated query. I need to create a report that shows the number of items of each different type per month within two dates selected on the initial access form. e.g. TYPE 10/07 11/07...

Hi, I've graduated from counting records to summing values now!! I've got the data set that is shown below caseNo source Amount Vat Total Date Paid 1 ted £50 £7.50 £57.50 01/01/08 I've actually around 3000 records going back to 2004. What...

Thanks guys, that's a big help.

Hi, I have a problem along the same lines and was wondering if you could help. Well, it is basically the same problem but I want seperate columns to count if a date has been filled in or not and if it is in a specific range i.e. ref user F closed date 1 JK 01/10/2001 2 JK...