Query

[dr223]

Hi,

I am working with access 2003, I have one table with three fields A, B and C. I am trying to write a query whereby if A=B it should be displayed with the respective C data.

For example

Bsc Mathematics = A
Bsc Mathematics = B
4 years course = C

In the above example A = B, so C will also be displayed when the query is run.

I have typed this in the criteria under A

=

however, it just brings empty columns. What's the problem?

Thanks

 

[KenHigg]

The values in column c are empty?

I think you can leave off the '='. And maybe use a trime():

trim()

???

 

[dr223]

Both the values in A B C are empty.

I have used the trim() function but it never worked it still brinngs forward empty columns.

any idea?

Thanks

 

[KenHigg]

Can you post a sample db with data and the query that doesn't work?