Print only non-integers

[cmd]

Hi all,
I have a calculated control on a report which sums the billing units
for each client for each month and for each type of service they
received.

Is there a way to filter the report to show only clients who have total
billing units which are NOT whole numbers?

e.g.,

client-1 total units: 10
client-2 total units: 3.5
client-3 total units: 2.25
client-4 total units: 16

-- I would like the report to show only clients 2 and 3

(perhaps I need to base the report on a Totals query, but I still need
to filter-out any totals which are integers).

Thanks for any help.
Mark

[Allen Browne]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<cm*@mountain.net> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...

Hi all,
I have a calculated control on a report which sums the billing units
for each client for each month and for each type of service they
received.

Is there a way to filter the report to show only clients who have total
billing units which are NOT whole numbers?

e.g.,

client-1 total units: 10
client-2 total units: 3.5
client-3 total units: 2.25
client-4 total units: 16

-- I would like the report to show only clients 2 and 3

(perhaps I need to base the report on a Totals query, but I still need
to filter-out any totals which are integers).

Thanks for any help.
Mark

[Allen Browne]

Yes: Create a Total query.

Presumably you have a field named Unit, and in the Total row under this
field you have Sum.

In a fresh column in the Field row, enter:
IntSumOfUnit: Int(Sum([Unit]))
In the Total row under this field, choose Expression.

Now in the Criteria row under your Unit field, enter:
<> Int(Sum([Unit]))

If you look at the SQL statement, you will see how the HAVING clause
interprets this.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<cm*@mountain.net> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...

Hi all,
I have a calculated control on a report which sums the billing units
for each client for each month and for each type of service they
received.

Is there a way to filter the report to show only clients who have total
billing units which are NOT whole numbers?

e.g.,

client-1 total units: 10
client-2 total units: 3.5
client-3 total units: 2.25
client-4 total units: 16

-- I would like the report to show only clients 2 and 3

(perhaps I need to base the report on a Totals query, but I still need
to filter-out any totals which are integers).

Thanks for any help.
Mark

[cmd]

Terrific! Thanks, Allen