Re: criteria

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks. However maybe I did not fully explain. I am calculating payroll. I
want to calculate pay for all persons, but additionally bonus only for those
persons whose ID is not numeric. As it is it is calculating bonus for all
persons. I would like it to return 0 for persons whose ID is not numeric.

"John Spencer (MVP)" wrote:

You can use IsNumeric to test if the value is a number.
The calculated field would look like:

Field: NumbersOnly: IsNumeric([YourField])

The criteria for that would be True if you only wanted the number fields.

You could also use criteria directly against the field
Field: YourField
Criteria: Not Like "*![0-9]*"

That criteria should exclude any field that has a character that is not a
number character.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Christina wrote:
I have a field in table , data type is text. For our own specific purpose
the ID in this field can either be a number or a letter. I would like to
return in a query, data from another linked table only if the data in the ID
field is a number. Is that possible?

Thanks

.

Relevant Pages

  • customize count/sum formula for overdue dates
    ... A1 is the cell for the date criteria that will determine how many ... The count should include text as overdue when calculating the number past due. ... Rqstor on Lv ...
    (microsoft.public.excel.worksheet.functions)
  • How to score a bracket pool
    ... When calculating points for an upset, do you use what really happens ... seed earning only 1 bonus point. ...
    (rec.sport.basketball.college)
  • Parameter Query and Date calculations....
    ... I am calculating a future date using the DateAdd function in a query (the ... the correct records are selected using the same criteria. ... Since both my criteria and the equation work correctly independantly I am ...
    (microsoft.public.access.queries)
  • Parameter Query and Date calculations....
    ... I am calculating a future date using the DateAdd function in a query (the ... the correct records are selected using the same criteria. ... Since both my criteria and the equation work correctly independantly I am ...
    (comp.databases.ms-access)
  • Re: Simplified GOAT Formula
    ... Like many, many people in our mixed-up world, Whisper is using the ... It is true that both counting slams titles and ... calculating "7543" points inarguably will yield higher numbers for ... basis of these criteria, on the other hand, is a highly subjective ...
    (rec.sport.tennis)