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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.