Re: SQL Query

you can't have 2 WHERE
- as in WHERE (WHERE

The < and > implies a non string (numeric) comparison
- so '[ ]' needs to be a numeric value (XX below) w/o a separator
(Shipments.Business_Unit > XX) AND (Shipments.Shipping_Group > XX)

If your Shipper string really has a ' in it you need to convert it to a double '
(Shipments.Shipper = 'N''ADP-Logistics')


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


"hrider1@xxxxxxxxxxx" <hrider1comcastnet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:118B973D-67F6-4AA1-9941-4A5AF6741649@xxxxxxxxxxxxxxxx
| Can someone tell me how to change the following query from SQL work in front
| page.
|
| WHERE (WHERE (Shipments.Business_Unit > '[ ]') AND (Shipments.Shipping_Group >
'[ ]') AND (Shipments.Shipper = N'ADP-Logistics')
AND (Shipments.Shipper = N'ADP-Logistics')
|
| This is all new to me
|
| Thanks,
| Jim
|
|


.