Search results

  1. S

    Query to count values in months between 2 dates

    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...
  2. S

    Sum of Values if in date range

    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...
Back
Top Bottom