30 daily dates then weekly dates afterwards

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dodat - 21 Sep 2006 22:57 GMT

Hi,

I'm trying to choose the first 30 days when a new entry comes into the table
by using this formula:

>=[date]+30

and with in the same query, i want to choose weekly dates after i have 30
daily dates.

is there a way for me to add:

weekday([date],2)

to this field or is it a completely different process?

Thanks,

Reply to this Message

John Vinson - 22 Sep 2006 00:38 GMT

>is there a way for me to add:
>
>weekday([date],2)

Try DateAdd("ww", [date], <number>)

John W. Vinson[MVP]

Reply to this Message

Dale Fye - 22 Sep 2006 03:15 GMT

If you are using "Date" as a field name, you need to change it to something
more meaningful. Date is an access reserved word, and using it as a field
name may eventually lead to JET having difficulty intrepreting your queries.
I usually try to put something descriptive as a prefix or suffix on my date
columns (Sales_Date, Start_Date, End_Date, ....)

HTH
Dale

> Hi,
>
[quoted text clipped - 14 lines]
>
> Thanks,

Reply to this Message