Recent content by RHomsey

Thanks a bunch .. That helps me out a lot .. The jpg really made it clear how simple what it is you were saying. **appluades**Thanks again

Can someone please help me on this?

The group by is present on all fields except for the one field (pump dates) which is set to max. It still brings up all records... here is my SQL: SELECT [Grease Trap Maintenance].[Company Name], [Grease Trap Maintenance].[Store #], [Grease Trap Maintenance].City, [Grease Trap...

It doesnt seem to be working. When i set my date field to max... it still brings up everything. Any ideas??

**BUMP**

Ok, so i have a query that pulls these records. Where is the query expression format entered at?? Sorry, i forgot to put im a total newb and do not understand access very well.

I am trying to create a query that will bring up a percentage. We have grades for store locations (they are grades for grease traps). I need to be able to have some thing like this: For (example) october .. 4% were A's 26% were B's...

Im attempting to create a query in which will show the most recent pump dates for all entries ... or for specific entries.. (meaning i dont want to have to type in every store number, becuase sometimes it will be over 100 stores that i need to find the last pump date). This shouldnt be too hard...

I just went through and tried to make a combo box and it was kind of confusing to me ... THere is a wizard that takes you through it... I see somewhat what i need to do but i still havent got it to work. Is there anyway you can tell me step by step how i get this to work?? All i want to put in...

I constantly put the same information into a form (ie addresses, company names, store numbers). The first thing i always put in is Company name and then the store number.. I am curious if there is a way for it to populate the address and zip code automaticly for me after i put in the store...

Thanks..! You have been a big help and i am forever grateful... Take Care

Ok, we are getting very close now :). The query you made above worked for me. But not quite exactly what i want....If im a bother please let me know... Anyhow, Im not sure how to get these queries to pull exactly what i want. What i want is to pull the 2 most recent dates from one (only one...

SELECT First(Date) AS [Date 1], First(Running Amps for Pump 1) AS [Amp 1], Last(Date) AS [Date 2], Last(Running Amps for Pump1) AS [Amp 2], iif([Date 1] < [Date 2], Last(val(Running Amps for Pump 1))-First(val(Running Amps for Pump 1)), First(val(Running Amps for Pump 1))-Last(val(Running Amps...

thanks again You are such a big help and I cant thank you enough.

Just so there is no confusion ... Is there anyway i can tell you my fields and you can post the query with those fields applied.. The reason i ask is because i get somewhat confused (dont laugh) as to of where to put my feilds.. I know once i get the first one done i can look at it and fill...