Recent content by danysfx
-
D
Date Query (last week, last 2 weeks, last month, last year, all)
Hi Any more help on the BETWEEN or the daterange function would be much appreciated. I found this: http://en.allexperts.com/q/Using-MS-Access-1440/Date-range-query.htm But it does not really help. Thanks Daniel -
D
Date Query (last week, last 2 weeks, last month, last year, all)
It seems that dateadd("d",-7,date()) is not giving the whole last week, it is giving the day that is 7 days back, e.g. today it is giving the date from 7 days ago, from the 24th only. I need the whole last week, not only 1 day. How do I have to use Daterange then? Thanks Daniel -
D
Date Query (last week, last 2 weeks, last month, last year, all)
Hi, thanks for that input I am still not sure how to implement that into my form. What kind of list or box should I use, so that I can click on "last week" or "last month". Thanks for further help Daniel -
D
Date Query (last week, last 2 weeks, last month, last year, all)
Hi Would be great if I could get some help on this: I have big table that gets updated almost every day with new data. There is a date column. I have a Form where I can enter queries. I need to add a panel where I can spcify if the query should involve the data should involve the date from...