Plus you don't have your new variable in the correct place
- and the FP DBRW doesn't write Select *
(it enumerates the variables in the Select statement as a coma separated list)
You have
SELECT * FROM Apmt1bed ORDER BY PriceEuros ASC
And should have say
SELECT PriceEuros, otherfield FROM Apmt1bed ORDER BY PriceEuros ASC
where , otherfield would be your other DB fieldname or fieldnames required as a coma separated list
And you would add your custom variable in the Select part as say
SELECT Format(PriceEuros,'#,##0.00') as fmtamount, otherfield FROM Apmt1bed ORDER BY PriceEuros ASC
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
"Kathleen Anderson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
Hi Mick:
Where did you make your changes? You should find the SQL in the gray-colored
code and make your changes. Save the changes while still in Code view. You
will notice that once you've saved your changes they are also made to the
maroon colored code - that is by design. The maroon colored code should
never be touched; it's generated by the gray code at save time.
What kind of errors are you getting?
--
~ Kathleen Anderson
Microsoft MVP - Expression Web
Spider Web Woman Designs
Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
Expression Web Wiki:
http://expression-web-wiki.com/
FrontPage Resources:
http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
"MickB Tenerife" <(E-Mail Removed)> wrote in message
news:0A57DEA7-026A-4675-8056-(E-Mail Removed)...
> Hi Stefan thank you for the reply, howeve from a novice, where do i insert
> the format code please.
> If I go to page 2 of the DBRW I get
>
> SELECT * FROM Apmt1bed ORDER BY PriceEuros ASC
>
> if I try to change it to
>
> SELECT * FROM Apmt1bed,
> format([priceeuros],'Currency') as fmtamount,
> ORDER BY PriceEuros ASC
> I get errors, any ideas please?
>
> "Stefan B Rusynko" wrote:
>
>> See
>> http://www.spiderwebwoman.com/resour...s.asp#currency
>> If you don't want the $ format, just use
>>
>> Format(priceeuros,'#,##0.00') as fmtamount
>>
>> --
>>
>> _____________________________________________
>> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> "Warning - Using the F1 Key will not break anything!" (-;
>> _____________________________________________
>>
>>
>> "MickB Tenerife" <(E-Mail Removed)> wrote in
>> message
>> news:296E2AF7-623E-480F-B371-(E-Mail Removed)...
>> Hi I have an issue with a field [priceeuros] that reports out as a sinle
>> interger, no commas, can someone help please
>> This is the second page of the DBRW I am experimenting with, but there is
>> a
>> syntax problem
>> SELECT * FROM Apmt1bed,
>> format([priceeuros],'Currency') as fmtamount,
>> ORDER BY PriceEuros ASC
>>
>> I have 1234567 and want 1,234,567
>>
>> thank you for your help
>>
>>
>> .
>>
Similar Threads
