Defaulting to Saturday date

[Virginia]

Hi all,

I have a field for a date to be input, and I want to create a query that
takes this date and returns another field with the date that Saturday. So if
Saturdays date is input it should show the same date, and any other should be
the next Saturday.

Any ideas please?

 

[tina]

in your query, try adding the following calculated field, as

BumpedDate:[DateFieldName]+(7-DatePart("w",[DateFieldName]))

the above goes all on one line, regardless of linewrap in this post. replace
DateFieldName with the correct name of the date field in your table, of
course. suggest you read up on the DatePart() function, so you'll understand
how it works.

hth