Search results

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'...

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

@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

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

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

Thanks for trying to help June

@June7 The field on the form just says #Error

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?

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

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

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

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

@tvanstiphout That works great, thanks

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

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

That works, thank you @plog

Hi all, Work has been really busy but as I was off work today I actually got around to making a form in the updated version of the database that I have been working on, I've added an additional combo box to add another criteria to the form, added a field on the form to build the title of the...

Sorry @plog I hadn't noticed that had been added in Thank you so much @plog & @Josef P. for helping & getting this working for me. More building of the new modified database & importing everything in, this is really going to help make my life easier with my current overloaded work load :)

Hi @Josef P. Thanks for joining in to help! The code is now working with the date fields :) Is there a way to stop the msgboxes from opening showing what filter is being applied?

No joy with that either, A msgbox opens listing the filter to be applied still, I can't see why as it wasn't doing that before. When I click on ok the report now opens without an error but the list on the report isn't filtered, sorry