Help with Access Input Mask Required

Conanius

Conanius

Conanius

Soldato
Joined
18 Oct 2002
Posts
12,856
Guys,

trying to set an input mask for an access database field in a table

must start with an uppercase H, be followed by any other upper case letter, and then 3 numbers... eg HG119 or HF221

cant for the life of me work it out, appreciate any help
 
its ok, I need more help !!

I need to do 2 validation rules

Field is a 'General Date'

The validation currently is Is Not Null

but it also needs to be... not in the past, and not more than 3 years in the future...

so is this something like (wrong code obv)

Is Not Null AND Is Not <Date() AND is not Date()+3 Years

if so, how do I write that?

also....

I have a field (another general date which currently also has validation of Is Not Null, but also needs to look at another General Date field and it MUST be greater than it (this is a field in the same table, entered just before this one)

any ideas on that one ? something like

Is Not Null AND Is Not < Fieldname

?
 
ok, worked out the first bit

Between Date() And DateAdd("yyyy",3,Date())

that should cover the not in the past and no more than 3 years ahead...

now what about the fact that the other field needs to be greater than this fields date?

would it be

Between Date() And DateAdd("yyyy",3,Date()) And > Fieldname?
 
worked it out, you have to do it in the table properties, not the field properties !

Last question....

I have a field in another table called duration, this is a byte, and contains numbers.

I want to add that to the departure date field, (adding that value as days) to give me a return date.... I want to do this in a query...

ideas?
 
You must log in or register to reply here.
Back
Top Bottom