First post, thank you for offering this site.
My question is in regards to Crystal 8.5, which I must use for application compatibility.
I am trying to build an estimate template to report on our database.
We estimate up to six quantities, and each is defined in the [qty no] field with a value 1 through 6.
Pricing rates and totals are different for each of the six quantities. The proper SQL syntax for returning the quoted price for, say, qty no 2 is below.
select
[quoted price] from dbo.pricing
where
[qty no]
= '2'
How do I write this VERY basic statement in Crystal 8.5 syntax?
Thank you!
Danny
IP Logged
