Search results for query: *

Les, Got it!!! I grouped PN, PA & Pln# as first, works like a charm. Thanks a million. Gonna send a pinkie your way. Stan

Les, I get 'em. It only shows 'CND' & Date, but I get 'em. Thanks a million Les. gonna work with it and see if I can attache the rest of data with it. Will let you know. Thanks again!! Stan

Les, I like the way the inner join works. The last one works but doesn't grab all the 60 CND's??

Was just thinking, I'm not great with these args. The 'CND' is a data and not number, would this effect Max? Wonderin' Stan

Hi Les, Thanks for the help. I run your query and it does the same thing. (All CND's come up). I am gonna put more info so you can get an idea what I use it for. Duane, I take a set of drawings from an architect and log them in. The Plan Number is Primary Key. There are 11 fields which get...

Duane, The table consist of 81 fields, I couldn't cut it down as to see what's there. Anyway, the 4 fields in first message are all i'm pulling out. If you would like, I can zip the whole MDB and send you a copy so you could kinda get an idea what it is. In short, it keeps a complete database of...

My lord that was fast, I'm not prepared. I'll go get a piece of the table and be right back. Thanks, Stan

Hi Duane, Thanks alot for the help. I tried it and it's query is much the same as mine. I made a couple of changes to see if I could get it to pull out consecutive numbers for plan rack, it no do. It did however, query less numbers (don't understand that). I am ready to shoot my screen. If you...

Table is tblReview Fields are Pln# PN CND Date Rcvd SELECT tblReview.[Pln#], Last(tblReview.PN) AS LastOfPN, Max(tblReview.CND)AS MaxOfCND,Last(tblReview.[Date Rcvd]) AS [LastOfDate Rcvd] FROM tblReview GROUP BY tblReview.[Pln#] HAVING...