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

Email notifications without opening application 1
Building an Expression for an Update Query 10
Display weeks from a Milestone 0
Append Crosstab Query to Existing Table 0
Sharing Access MDB or Accdb with client using older or newer version of Office 1
Expiry dates query 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
New Bug in Track Changes in Word 365 0

Top