Search results for query: *

MichaelRed & r937, You guys are great! The string function was the easiest to plug into my existing query and it is working beautifully. I truly appreciate your help, and this forum. I am self taught on Access and I muddle through, it is nice to have people to go to that are...

Well r937, The situation I have is as follows. I am working with an operations data base that records runtime within a month. All of the data was recorded once a month, usually during the last week but not always on the same date. Sample - I have run hours of 157 and mechanical downtime...

Thanks MichaelRed for your help on this. I am probably doing this wrong somewhere, but my mind has locked up on this and I am stumped. I pasted the following in a new query SQL, SELECT DISTINCT Count([ce_site_volumes]![volume_dt]) AS NumDts FROM [ce_site_volumes] WHERE...

MichaelRed, This looks like what I need. One question in the first line MyDate = date () can it be MyDate = [any specified date] WHer any specified date = the date field within my query? Larry

My Data in my Table is listed by Date, in my query I need to run a calculation on the number of days in that particular Month. Is this possible? Larry

One other bit of information, The fields [Change Date] and [New Cost] are Null if no Rate increase has been implemented on specific Units. [UnitID] is a filed in both tables.

Thank You for your response, nsukari I apologize, The Table [OpData] is a table of operational data on rental equipment. The Field [OpData]![Month] is the month in which that data was recorded. The Table [Unit_Rental_Info] relates to the monthly rent that is paid on the equipment...

I have a DataBase Table [Unit_Rental_Info]. My fields are [Unit #], [Total Cost], [Change Date], [New Cost]. I need my code set up so that in my Query it will show the [Total Cost] for all date ranges up to [Change Date], and the [New Cost] for all date ranges after Change Date? I tried...

I am working on a data base on rental equipment. I have [Site], [Unit #], [Monthly Flow], [Month], [Start Date] & [Stop Date]. My Monthly Reports are working fine and the totals are accurate. My problem is when I try to do a Quarterly Query, I get duplicate numbers combining [Unit #] &...

Thanks for looking at the post - I was able to put the charts in a Site Footer and used the following code - Written by Eddie Rae Melton - Must give credit where credit is due- She saved my project. Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer) If Text163 =...

I have an extensive report on equipment operating conditions. I am currently working with 100 pieces of equipment separated into 3 groups of "Critical Unit", "Mid-Range Unit", & "Non-Critical Unit". I am using 5 historical graphs, which I have designed for 5...