Search results for query: *

if I have TableA A B C 1A 1B 1C 2A 2B 2C 2A 3B 2C How do I get results: 1A 1B 1C 2A 2B 2C Thanks, Mark

Thanks, A varaition of the last SQL will do just fine.

Thank you. That would work great but I just realized the table is like this A B C 1 X AA 1 Y BB 2 X AA and I want 1 BB because B = X

TableA A B 1 X 1 Y 2 X I want my results to be 1 X because B = Y. This is kind of what I was tring: SELECT DISTINCT A, CASE WHEN B = 'X' THEN B ELSE '' END AS B FROM tableA WHERE B = 'Y'

Thank you very much.

How do you combine text and a Field value in a text box? I have tried: Customer: = Fields!Customer.Value and "Customer:" & Fields!Customer.Value

I have: FieldA FieldB FieldC A 1 10/10/2000 A 1 10/11/2000 A 1 10/09/2000 B 1 11/11/2000 B 1 11/09/2000 How do I get: A 1 10/11/2000 B 1 11/11/2000 Thanks

This is working, I had to RTRIM() the value. Thanks

That doesn't seem to work. I have 3 a's and 2 b's and my =Sum(iif(Fields!MyLetter.Value = "a",1,0)) & =Sum(iif(Fields!MyLetter.Value = "b",1,0)) both return 0. Thanks

Thanks.

I have a table column that could have either "a" or "b". How do I get a count of how many "a"'s? I know I am just overlooking something very obvious. Thanks