Help with SQL please

[Paul M]

Hi
This SQL works fine but it displays both the formated
fmtAmount_required and the un formatted Amount_required.
When I remove the Amount_required from the SELECT
statement it produces a database error What am I doing
wrong?
The SQL is:

SELECT Format([Amount_required],'Currency') AS
fmtAmount_required, Amount_required, Project_title,
Sponsorship_type, Geographical_location,
Short_description, Project_ID FROM Results WHERE
(Amount_required <= ::Amount_required:

This is the error:

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

Thanks
Paul M

 

[Jim Buyens]

Howdy.

Rerun the DRW, leave the SQL as is, and on page 3, click
Edit List and remove the Amount_required field.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------