If you hardcode it =Nz(DSum("OrderTotal","qryOrderSummary","OrderDate >=#3/6/24#"),0) does it work?

Hi Alex it won't let me reply to you?
Yes that works hardcoding the date but that would mean changing the date everytime.
Also your date format is different which works but when i change it to 06/03/2024 it doesn't?

I've had so much trouble with programming date fields from the US using mm/dd/yyyy then sending it to someone internationally who uses dd/mm/yyyy. Is your Date-7 the right numbers for your last 7 days? Or is it potentially calculating a different date range using mm/dd instead?

I'd suggest looking into ISO Date Format ISO Date Addendum 1

ISO is the WAY TO GO!

Hi Adam
Yes it displays the correct amount for -7 -14 -365 days.
I put the function "Date()" in a text field on the form to see it it was formating correctly, it was, it seems only to be for the 1 day field it doesn't work?
tried the ISO date format still the same?
I'm biting chunks out my screen trying to figure out why lol :)
Regards
Steve

So just to confirm there's no weird issue with the mm/dd vs dd/mm. When you make a textbox with Month(Date()), is that coming up as 3? and a textbox with Month(OrderDate) is the same for todays stuff?

Hi Adam
No there seems to be no other issue and yes it shows 3
Even the chart has the right amount for the dates in it it only seems to be for the daily sales?
I've rebuilt the textbox about half a dozen times even tried a new form same problem exits is bloody weird?
Regards
Steve

Yea strange, something else must be off. Few other ideas that may be doing something weird.

Is Time a factor at all? Is OrderDate just a date or with time? Shouldn't matter with >= but just throwing it out there if it sparks an idea.

Does doing >Date()-1 work? (no equal, assuming no times)

Also to confirm, when you open up that specific query the records with todays values are actually showing in that query? There's no weird criteria stuff going on.

Hi again Adam
All the dates show in the query with the 06/03/2024 format
There doesn't seem to be an issue with the date format because it shows the correct sales amount for all other date criteria
On the graph it shows the correct day with the correct sales for that day?
it's just in that one text box that has the problem for the daily sales?
I only put the year texbox on the form just to see if it works and it does?
the table shows the dates correct, the qry shows the dates correct it just won't show on the form for the daily sales that Richard displayed?
Regards
Steve

Did >Date()-1 work and give you only todays?

No Adam the Date()-1 just shows '0.00

I was just re-reading through the post and seen this

Also your date format is different which works but when i change it to 06/03/2024 it doesn't?

I would be inclined to think it's almost certainly a mm/dd vs dd/mm thing. This is one of the reasons I stopped doing jobs for international people and moved to ISO Dates. You pull your hair out on stuff like this :(. If the chart your talking about uses the same query, it just may behave differently than a text box does, hard to say without testing. I would just advise moving over to ISO dates completely, did you also watch the ISO Date Addendum 1? We don't just want to format them.

Hi Again Adam
Yeah I followed Richards advice and changed my computer over to ISO but it was still the same. Also the adendum tried that but still no joy.
Funny enough I tried -1 to -3 nothing but when i put -4 it shows the sales from  the begining of the month?
I think I'll try another route like a query for daily sales or something.
Best Regards
Steve

Instead of explaining what you've done that doesn't work, how about explaining what you're trying to do in plain English?