Question Expression Help?

[carrybag93]

I have a Yes/No field, called 'VIP?', and I would like it to automatically tick itself if:

1. The field 'Order Count' is equal to or greater than 10
and/or
2. The field 'Order Total' is equal to or greater than $1,000

Any ideas? Where would I put this expression into?

 

[Trevor G]

You would need VBA code for this unless you are using Access 2010.

 

[carrybag93]

What is a VBA code?

 

[Trevor G]

VBA code is the programming language which stands for Visual Basic for Applications.

Behind the scenes when you want something doing and can't find a solution from the front of Access or Excel etc then you end up writing VBA code. Look at YouTube for something like Learning Access VBA

 

[carrybag93]

Ok, thanks

 

[Simon_MT]

Update Query, I don't know how you get Order Count but it would be easy enough to using subForms to count the Orders and Total Order and bring these values onto a parent and onCurrent Set VIP to True.

If [VIP] <> True
If [Order Count] => 10 or [Order Total] => 1000
[VIP] = True
End If
End If

Simon

 

[carrybag93]

How can you put code in a query? Isn't a query just a way to display data how you want?

 

[Simon_MT]

You use an event on the Form's Property Sheet.

Send up an example I show you how.

Simon

 

[carrybag93]

I will pm you my database.