(Access '97, Win '98)
I'm hoping this is fairly simple... let's see : )
I have a pool of tickets to be given away, people can apply for upto 10 but only the first 4 are guaranteed. The rest are put into a draw and may or may not be received.
To represent this in the Access Db I have built for the people answering the ticket lines what i want to do is this:
Have one input box into which the user will type in the total number of tickets ordered (say 10), there should then be a further field which displays the number that hence need to be put into the draw (10 - 4 (the guaranteed tickets)).
The field name of the tickets ordered field is fldTicOrd. I thought about using the default value and putting it as fldTicOrd - 4 but am not sure of the syntax to this. Could anyone inform me? Also is there a better way to do this?
Thanks in advance for any help.