30 daily dates then weekly dates afterwards

[dodat]

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,

 

[John Vinson]

is there a way for me to add:

weekday([date],2)

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


John W. Vinson[MVP]

 

[Dale Fye]

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,

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,