search coding

[Masoud]

thank you for yor comments.

I Think my problem is in Total query (max),but I can't solve it at the coding.

as I explained at the most of times I need the result of my search brings

DOCUMENT No title max transmittal max DATE
Group by Group by max max


so I have made a Total query (by max) that takes the "WHERE CONDITION" from
coding
and gives me the result.but some times I
have to search transmittal that is not the maximum at the group,so according
to
coding it finds Document no correctly but the transmittal is not what i was
searching
for that, it brings max transmittal for that document.for example for
searching "t-002"
in this example as below it does like this.

Doc No Title Transmittal

st-dwg-1001 test t-001
st-dwg-1001 test t-002
st-dwg-1001 test t-003

it brings.

Doc No Title Transmittal

st-dwg-1001 test t-003

Thank you so much.

 

[jahoobob via AccessMonster.com]

Did you change the field name DATE as I said? If you didn't, then there is
no sense in moving on. This could be the cause of your problem. As I said
in the other thread, reserved words as field names tend to confuse SQL.