Search results

There is a article in a small town in the US, where most of all it's residents had concealed weapons permits and carried gun. There was near to zero gun crime. Would you try to rob anyone? I'll look for the article

Would you bring a knife to a gun fight? Guns are going to be associated with very bad people, I know I want protect my kids, ok my wife too. If someone breaks into your house, can your baseball bat stop a bullet?

where is your james bond to save us? sorry woke up on the wrong side of the bed

Or was it just cool to say?

We got oil??? Man this $3 dollar gas helps me out :P If US took the oil, why is our deficit still high?

The query grid was the key. Sometimes you have to step-back and try the most simple way. I was just over-analyzed... sometimes you just got to take a break.

SELECT [Liner ID #], Max([Date Inspected]) AS [MaxOfDate Inspected] FROM [Liner A] GROUP BY [Liner ID #]; I DID IT !!!!!!!!!!!!! If anyone had that problem you can use that format... now I'll go back to dancing in my office

Select [Liner id #], [record number] From [Liner A] Group by max[date inspected] Seem like it should work, but I getting "Error -2147217900: Syntax error (missing operator) in query expression 'max[date inspected]'." Help me obi wan, your my only hope

I have tried these queries and can't get the results I want. I have a list of Liners (ex... A-1-1, A-1-2, A-1-3 and so on...) with multiple dates and inspection data. There is something I'm not grasping... Is there a Where statement I can filter only the most recent date or a Having...

I have removed the relationship and still can't remove a field. Any help?? I also tried compact and repair and then still will not delete.

Ok here is my project.... Any Access Masters comments are greatly welcome. Ok need help in Query [Active Liner A] or [Tot ACT Liner A] Trying to just get list of liners with most recent date inspected. I just can't grasp the right way to query.

SELECT DISTINCT [Liner id #], Max[date inspected] Is not working am I missing something?

Is there a query function that can do this or do I have a make All new tables for Each [Liner id #] Might be 90+ tables just for each liner

That is what I'm try to say... Measure Date is going to be changing. This ITEM [LINER ID#] is going to be a changing item with changing Diameters. As the tool is used the diameter changes. So the tool [liner ID #] will stay the same I want the most recent diameters and when it was inspected...

Well not exactly I did get a list of all Active, but the distinct only works on one field. Is there anyway to filter all other thru most recent date? I need most recent date code

Thanks I'll try that

Is there any way to change the color of the command buttons? I know you have change text inside the button, I want to change the whole button color.

I DID IT....it is Distinct

Oh I found it. I had to use a Parameters query

Yes (Dia1 Dia2....) are just diameters which the maintenance person measures the die at that point. These dies will constantly grow within a group of tolerances. Group of tolerances = to diameter of product. They usually buy the dies with a small diameter then get bored to the next size up...