Recent content by PaulD2019

  1. P

    Multiple criteria on DCount including date field

    Apologies @Pat Hartman , Noted Thanks for your help, neither of the below work in the listed format =DCount("StatusName";"tblJobRefBook";"JobStatus = 'Quoted' AND QuotedDate < Date()" ----would have worked although it is inefficient compared to =DCount("*";"tblJobRefBook";"JobStatus = 'Quoted'...
  2. P

    Multiple criteria on DCount including date field

    Thanks Eugene, that has got it working in the text field, it is showing 531 instead of 565 still though. I am going to do a cleanup of the projects that have been quoted tomorrow, I will see if that sorts the count out after the old jobs have been removed. The table has got quite a bit of...
  3. P

    Multiple criteria on DCount including date field

    @Eugene-LS That says the expression you entered contains invalid syntax @June7 Your query seems to be close to working, I am really scratching my head trying to suss out why the figure counted is wrong though @Pat Hartman Thanks for your info
  4. P

    Multiple criteria on DCount including date field

    Thanks @Eugene-LS my regional date format is DD/MM/YYYY The field says #Error with that added unfortunately though
  5. P

    Multiple criteria on DCount including date field

    Hi June In a query that says Extra ) in query expression [JobStatus] = "Quoted" AND QuoteDate >= Date()-30) I removed the ) at the end & the query worked but it showed the amount of projects that were under 30 days - 39 projects in total Changing the > to a < corrected the issue but the...
  6. P

    Multiple criteria on DCount including date field

    Thanks for trying to help June
  7. P

    Multiple criteria on DCount including date field

    @June7 The field on the form just says #Error
  8. P

    Multiple criteria on DCount including date field

    Thanks for your help @June7 I tried the below in the field on the form but I am still getting an error =DCount("Quoted","tblJobRefBook","[JobStatus] = 'Quoted' AND QuotedDate >= Date()-30)") Have I added what you posted wrong?
  9. P

    Multiple criteria on DCount including date field

    Hi all, I am working on a form to show different statistics on the database I am working on, the quotations raised on the database are valid for 30 days, after 30 days we send a quote reminder via email (already set up) & another 30 days are added before the quotation is cancelled on the...
  10. P

    Query to group by two fields & average the final field

    Thank you @June7 I will give that a try when i get home
  11. P

    Query to group by two fields & average the final field

    Hi all, I am sure I have done something like this before but I can't find the database I tried it on. I would like to create a query to group the sample data shown below to use in my main database I am working on, the material type has up to three different project types that it can be carried...
  12. P

    Sorting a query for selected dates

    Hi, It is a number field that adds the client id number to the table
  13. P

    Sorting a query for selected dates

    @tvanstiphout That works great, thanks
  14. P

    Sorting a query for selected dates

    Hi all, i need to make a new report on the database I created for use in our office so we can find the top spending clients between two dates selected on a form, I guess it will be mainly used for top spends by clients for the year but being able to choose selected sales between two dates would...
  15. P

    Creating a report from multiple criteria

    It is what is needed & previewing isn't required, the report will be used to record & save the data on a 3 monthly basis for various material types that our staff remove, it doesn't need to be previewed first as it collates data that has been added on one of the forms of the database, I will add...
Top Bottom