Filter by week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Like this:
I have a field in a table is type date, and i want to make calculation by
week in form, so is possible to filter all the date by week and make
calculation in them?
 
You can do it in a query. Put the following in a field

WeekNo: format([fieldname],"ww")

This will classify a date according to what week of the year it is. Then you
can base your calculations on it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

main form based on table with no date field-need to tie-Sun dt w/s 2
Searching/Filtering Form by Date Calendar: Week Beginning... 1
Help 5
Hiding a button based on a value in a table 1
CALCULATED VALUES FROM CURRENT VALUES IN AN ENTRY FORM 2
Caclulated Field Doesn't Always Work Properly 7
blank form, can't insert new record 11
iif exists - too complex? 1

Back
Top