Building Expression for an Update Query

H

Hasas

I am new to access and need someone to help me build an expression. I need to
update the "expiry date" field in certain records so that when I run the
query it changes the "expiry date" to be two weeks before the beginning of
each month. Can anyone tell me how to do this?? I am using Access 2003.
 
S

ShaneDevenshire

Hi,

You should post Access questions to the Access area rather than the Excel
area.

What we or they would need to know is what is the condition which determines
which records to update.

In anycase you need to go to the Query design area and create an Update
query. Look at the Help system for Update query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Building an Expression for an Update Query 10
Access Microsoft Access Calculated Field - Expiry Date 0
Expiry dates query 1
Need expression for next month's expirations?? 9
Access Building a IIF expression in Access 0
Access Query problem 1
MS access Form calculation 5
Need help with a search function - vlookup or ??? 2

Top