functions in a query

C

catherinejones

I have a query I need a date field to equal 30 days from the current date
example (field name)+30. Is this possible. If so please give me the
formula in where to insert it in the design of the query.

Your help is greatly appreciated.
 
M

Micah Chaney

Catherine "Zeta" Jones by any chance?
In your Query...Create a Field with this name exactly:

Date: Date() + 30

That tells it that field today's date plus 30 days. Of course all the
fields in that record will have that same value...is that OK? Also tomorrow,
that date value won't change, only for new records. Is that OK? Let me know
if this helps.

Miss you in those T-Mobile commercials...what do you think of your
look-a-like?
 
M

Micah Chaney

I'm sorry I said that wrong...All the records in that Query will have that
same value for that field. Not all the fields in the record. I'm sure you
wouldn't want that.
 
V

Van T. Dinh

Set the criteria on your DateField to:

= Date() + 30

provided that you don't have the time component (i.e. zero time component)
in your DateField values.
 
Top