Setting into Integer

[lerwane]

please help!


I have a query wherein i want the data to be displayed as Integer not a Float/Double. How will i set it? Since there's no data type field in query part.

please help ASAP. Thanks

 

[lerwane]

hi!

but is there a way just to set it up in query design?

 

[WayneRyan]

lerwane,

If you have a field defined as a number a query will let you
further qualify that: (General, Currency, ...).

If you are introducing a new field, or need a specific number of
decimal places (or integer), then you will have to resort to
using a function like Pat said (CInt).

Wayne

 

[lerwane]

thanks

Thanks a lot guys!