I have updated an order for a customer for the 5th February 2025 (which is a date in the last 30 days) and so should be displayed on the MainMenuF using the property =DSum("LineTotal","OrdersForStatsQ","OrderDate>= #" & Date()-30 & "#"). Only it doesn't!. The box is blank and stays blank after using the query refresh button. However, if I change the property to =DSum("LineTotal","OrdersForStatsQ","OrderDate>= #" & Date()-38 & "#") it does display the total value of the orders in the last 30 days. ie £1559.95. Any less than 38 results in a blank box.
Alan StevensOP
@Reply 19 months ago
Kevin Robertson
@Reply 19 months ago
I'm thinking it may be a formatting issue. Access may be looking for US standard date format.
Try using the Format Function.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.
