Basic Question on a (Fairly) Basic Query (1 Viewer)

[E.Rowlands]

Hi,

Could any Access experts let me know if this is possible, and how it would be achieved:

1. I have an update query.

2. It updates the costs of treatments by a reduction of £5.00 (criteria is in
DOB field <=#01/01/1950#)

3. I have a field that says: "Discount Applied?" - My query will update the yes/no value to True.

The problem I have (which is now obvious to me why it would happen) that even if the relevant fields defined by my DOB criteria aren't returned, and therefore not updated, the "Discount Applied?" field WILL return (again, of course) and will be updated to true.

Is there any clever way I can make it so that the "Discount Applied?" field is only updated on the condition that the DOB criteria is satsified (IE, born on or before 1950).

Many thanks.

Eric Rowlands

 

[E.Rowlands]

Sorry to waste anyone's time!

I am a complete beginner in access... so leaving possible SQL statements behind, considering I thought that SQL was the only solution, I have worked it out!

I just made another query, relevant to the criteria I needed, then put that query and the relevant table in my update query!

Phew.