Solved Link Date Picker Control to Query & Macro Function (1 Viewer)

[Sarah.M]

Hi, Plz note, My VBA is disabled for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
Hi, I make Statistic Form and Query, to count orders Today, Week, Month and Year, and to make it fixable I add buttons
in Macro I use number manually I think if there is functions it will be more accurate, plz help me to make it accurate:
1. I could not link Date Picker with query, becuse the "Total is enabled"
2. Week how can I make it accurate?
3. Month sometimes 29 or 30 or 31 how can I make it more accurate?
4. Year how can I make it accurate?

Sample Attached

 

[Ranman256]

all these are already accurate. Year(datefld) give you the year....etc.
Date picker only picks dates.

i would use 2 date fields: txtStartDate and txtEndDate.
then using the form, you can set 'date groups' like monthly that sets the Start/End dates for you.

then your query can pull from the form:
select * from table where [DateFld] between forms!fMyForm!txtStartDate and forms!fMyForm!txtEndDate

 

[arnelgp]

here check and test your stat form