Criteria (*0.25*.50-*.75)

[Guest]

Hello,

I want to make a Field with a criteria.
It should only accept numbers that are *.25 - *.50 - *.75 - 1 -1.25 - 1.50,
and so on.

how do I create a criteria that does this?

Thanks in Advance

Grtz

 

[Allen Browne]

Try setting the Validation Rule of the field in your table to:
(4 * [MyField]) = Int(4 * [MyField])
substituting the name of your field for MyField.

 

[Guest]

Hallo,

I tried you're Criteria with different settings, but it didn't work :s

Is There another solution?

Try setting the Validation Rule of the field in your table to:
(4 * [MyField]) = Int(4 * [MyField])
substituting the name of your field for MyField.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I want to make a Field with a criteria.
It should only accept numbers that are *.25 - *.50 - *.75 - 1 -1.25 -
1.50,
and so on.

how do I create a criteria that does this?

Thanks in Advance

Grtz

 

[Allen Browne]

Perhaps we should clarify what you are wanting to achieve. Did you want to
design a table where you can only type in numbers that are quarters: 0.25,
05, .75, 1, etc?

When you opened your table in design view, what was the Data Type of the
field you tried it with? And in the lower pane of table design, what was the
Field Size property?

How did it fail? Did it accept a number it should have rejeced? Or did it
reject a number it should have accepted? Was that number already in the
table before you added the validation rule? Can you give me an example of a
number that failed?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hallo,

I tried you're Criteria with different settings, but it didn't work :s

Is There another solution?

Try setting the Validation Rule of the field in your table to:
(4 * [MyField]) = Int(4 * [MyField])
substituting the name of your field for MyField.

I want to make a Field with a criteria.
It should only accept numbers that are *.25 - *.50 - *.75 - 1 -1.25 -
1.50,
and so on.

how do I create a criteria that does this?

 

[James A. Fortune]

Hello,

I want to make a Field with a criteria.
It should only accept numbers that are *.25 - *.50 - *.75 - 1 -1.25 - 1.50,
and so on.

how do I create a criteria that does this?

Thanks in Advance

Grtz

Allen's combination of humility and great knowledge of Access is
inspiring. Nevertheless, I'd like to point out an alternative method
that offers some additional robustness:

http://groups.google.com/group/comp.databases.ms-access/msg/afc4df1d5d81c109

Note: In the same thread Bas Cost Budde suggested something just like
Allen's example except without the initial set of enclosing parentheses.

James A. Fortune
(e-mail address removed)