Frmat help please

[Paul M]

Hi
I am attempting to query a field sponsorship_amount and
format the results but it seems to duplicate the record.
Here is the SQL

SELECT Format([Amount_required],'currency') AS
fmsAmount_required ,* FROM Results WHERE
(Amount_required <= ::Amount_required::

I wish only the formatted record to return
Thanks
Paul M

 

[Thomas A. Rowe]

Remove the * and specify each field that you want returned.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Paul M]

Thanks Thomas

-----Original Message-----
Remove the * and specify each field that you want returned.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

Hi
I am attempting to query a field sponsorship_amount and
format the results but it seems to duplicate the record.
Here is the SQL

SELECT Format([Amount_required],'currency') AS
fmsAmount_required ,* FROM Results WHERE
(Amount_required <= ::Amount_required::

I wish only the formatted record to return
Thanks
Paul M

.