Export to text - no decimals

G

Guest

Hi,

I am having trouble exporting a file and would appreciate anyone's
suggestions. I have a numeric field that I have tried to format as an
integer (with no decimals) that (no matter what I've tried) shows up with two
decimals.

Here's the last SQL I tried:

SELECT MASTER.LICSTATE AS lic_state, Format(master.LASTUPDATE,"mm/dd/yyyy")
AS last_updt_, MASTER.URL AS parent_nm, MASTER.OFFICEORG AS org_name,
MASTER.SLNUM, MASTER.LICTYPE AS lic_type, MASTER.ADDRESS1 AS address1_1,
MASTER.CITY AS city_1, MASTER.STATE AS state_1, MASTER.ZIP, MASTER.PHONE AS
tele_1, MASTER.ADMINNAME AS contact, CLng([MASTER].[BEDS]) AS tot_lic,
MASTER.BEDTYPE AS afftype1, MASTER.LIC2 AS ex
FROM MASTER
WHERE (((MASTER.LIST)="MELIST"));

Thanks in advance.
 
G

Guest

That looks like it Jerry. I tried CLNG() but not the ,0. Thanks for the
help. I'm going out to my office to give it a try.

Thanks.

Jerry Whittle said:
Format(CLng([MASTER].[BEDS]) , 0)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Bonnie said:
Hi,

I am having trouble exporting a file and would appreciate anyone's
suggestions. I have a numeric field that I have tried to format as an
integer (with no decimals) that (no matter what I've tried) shows up with two
decimals.

Here's the last SQL I tried:

SELECT MASTER.LICSTATE AS lic_state, Format(master.LASTUPDATE,"mm/dd/yyyy")
AS last_updt_, MASTER.URL AS parent_nm, MASTER.OFFICEORG AS org_name,
MASTER.SLNUM, MASTER.LICTYPE AS lic_type, MASTER.ADDRESS1 AS address1_1,
MASTER.CITY AS city_1, MASTER.STATE AS state_1, MASTER.ZIP, MASTER.PHONE AS
tele_1, MASTER.ADMINNAME AS contact, CLng([MASTER].[BEDS]) AS tot_lic,
MASTER.BEDTYPE AS afftype1, MASTER.LIC2 AS ex
FROM MASTER
WHERE (((MASTER.LIST)="MELIST"));

Thanks in advance.
Click to expand...
Click to expand...
 
Top