search coding

[Guest]

thank you.
I renamed the date field but my problem still there is,
i think my problem is in coding or total query(max) for this cases but
i don't know how i have to solve.

Regards.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...58ba8c&dg=microsoft.public.access.formscoding

 

[Guest]

Sorry, we can not see your problem. You did not say what was not happening
or what it was doing wrong.

Post your SQL by opening the query in design view, click on menu VIEW - SQL
View, highlight all, copy, and paste in a post.

 

[Guest]

Hello,
SELECT qrymaxTransmittal.Originator, qrymaxTransmittal.DISCIPLINE,
qrymaxTransmittal.TYPE, qrymaxTransmittal.DocumentNo,
qrymaxTransmittal.TITLE, qrymaxTransmittal.PLANT, qrymaxTransmittal.ZONE,
qrymaxTransmittal.[CIVIL UNIT], qrymaxTransmittal.[PROCESS UNIT],
qrymaxTransmittal.MaxOfREV, qrymaxTransmittal.MaxOfTRANSMITTAL,
tbltransmittalNo.RevDATE
FROM qrymaxTransmittal LEFT JOIN tbltransmittalNo ON
qrymaxTransmittal.MaxOfTRANSMITTAL = tbltransmittalNo.TRANSMITTAL
GROUP BY qrymaxTransmittal.Originator, qrymaxTransmittal.DISCIPLINE,
qrymaxTransmittal.TYPE, qrymaxTransmittal.DocumentNo,
qrymaxTransmittal.TITLE, qrymaxTransmittal.PLANT, qrymaxTransmittal.ZONE,
qrymaxTransmittal.[CIVIL UNIT], qrymaxTransmittal.[PROCESS UNIT],
qrymaxTransmittal.MaxOfREV, qrymaxTransmittal.MaxOfTRANSMITTAL,
tbltransmittalNo.RevDATE;

As I wrote some times I need to search transmittal that are not maximum in the
group so wih this query in the search result i can find document NO for
that Transmittal but it bring max transmittal in the search.for example
search "t-002"
Doc No title transmittal
st-dwg-0001 test t-001
st-dwg-0001 test t-002
st-dwg-0001 test t-003
it brings.
Doc No title transmittal
st-dwg-0001 test t-003


I like to know there is any way in VBA (I Posted before) for developing my
search
or i have to make another form and query for theese cases.

Best regards