Try to write a sql statement that I didn't have any
problem with in Access.
Fields: Rec_Type, Amount
Need to write an "IF" Function that says something like IF
Rec_Type = 1 then Amount else 0
BUT, I can't have the Rec_Type in the Select Statement.
So I tryed,
Select Case when test.rec_type=1 then test.amount else 0
But I get an error stating that I can't use Rec_Type
because it is not contained in the Select Statement.
In access this wasn't a problem
Any help would be greatly appreciated