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.