Vitajte na [www.pocitac.win] Pripojiť k domovskej stránke Obľúbené stránky

Domáce Hardware Siete Programovanie Softvér Otázka Systémy

What would be validation rule for every value to begin with the letter E or V in Microsoft Access?

In Microsoft Access, you can't directly use a regex-like expression within the validation rule itself. You need to use a workaround involving the `Left()` function and the `In` operator.

The validation rule would be:

```sql

Left([YourFieldName],1) In ("E","V")

```

Replace `[YourFieldName]` with the actual name of your field.

This rule checks if the leftmost character (the first character) of the field's value is either "E" or "V". If it's not, Access will display the validation error message you've set for that field. Make sure to set an appropriate validation text message in the field's properties to inform the user of the required format.

Najnovšie články

Copyright © počítačové znalosti Všetky práva vyhradené