Whole Numbers

[stapuff]

I have following as a field:

Qty: [SHIP_QUANTITY]*-1/[PMCUBE]

I do not want to see and records where the result is not a whole number. One thing I do not want to do is round the number and I can not change how the data comes into the tables I am quering.

Any suggestions would be appreciated.

Kurt

 

[stapuff]

I have this figured out:

1st field:
Qty: [SHIP_QUANTITY]*-1/[PMCUBE]

add another field
2nd field
Qty1: IIf(Int([SHIP_QUANTITY]*-1/[PMCUBE])=[SHIP_QUANTITY]*-1/[PMCUBE],1,0)

in the criteria of the 2nd field - put a 1.

Using the int - the decimal is turned into and Interger and checked against itself. If it is a decimal - field 2 should be a 0 if the match 1.

Kurt

 

[xenou]

In one field is possible maybe?

IIf(Int([SHIP_QUANTITY]*-1/[PMCUBE])=[SHIP_QUANTITY]*-1/[PMCUBE],Int([SHIP_QUANTITY]*-1/[PMCUBE])=[SHIP_QUANTITY]*-1/[PMCUBE],0)

 

[SydneyGeek]

Or,

Iif([SHIP_QUANTITY] Mod [PMCUBE])=0,([SHIP_QUANTITY]*-1/[PMCUBE]),0)

Another option:

(([SHIP_QUANTITY] Mod [PMCUBE])=0)*([SHIP_QUANTITY]/[PMCUBE])

If the remainder is 0, you have a whole number. The first option spells it out with an Iif statement. With the second option, the first half of the equation will evaluate to TRUE (-1) or FALSE (0).

Denis

 

[stapuff]

Alexander & Denis -

I like your suggested alternatives. I appreciate the support.

Kurt