Adding total dates in a text box
When a vehicle is put in shop to be worked on it is given a date called "InshopDate" and vehicle unit and a serial number is also Entered.
If the vehicle is in the parkinglot and not getting worked on it is not given "InShopdate" but a unit name and a serial number.
(I need to find out how many of a certain unit are in shop being worked on.
My strategy is to add the total of a certain unit with a "inshopdate" minus the total of all of a certain unit. So this is what I have But I keep getting a error. Which just says #error
=DCount("[InShopDate]"," tblTempleFuelCellOnly","[U
Now if there is a better way to this by all means expert please let me know. By the way this is hard coded in a text box.
=Dcount("InshopDate"," tblTempleFuelCellOnly","[U
This should only count Records where Inshop has a value and Unit=FY10
Is this what you wanted?
"I need to find out how many of a certain unit are in shop being worked on."
JeffCoachman
Remember that we are trying to address your question as posted.
If it were me, I would simply add a "Inshop" yes/no field to the table instead of relying on a Date/No Date field to determine if it is in the shop or not.
Then the syntax would simply be:
=Dcount("Inshop","tblTempl
But again, there may still be somethings that need clarification...
JeffCoachman
I mean like this to see inshop (Yes) for a certain unit (FY10)
=Dcount("Inshop","tblTempl
InShopDate=Date working on(date data type)
DateCompleted=when they finished with the vehicle(date data Type)
DateReturned= when the vehicle is picked up.(date Data type)
Units= FY10, FY9, 278Th (Text Fields)
From this information they want to know the following:
1. Total Onsite (meaning both ones not in shop and the ones are in the parking lot)
2. Total Awaiting shop(meaning there in parking lot but have no date yet that they are in shop)
3. Inshopdate(meaning being worked on but not completed yet)
So they can have a inshop date and date completed which would mean it wouldnt be counted as inshop. Sorry guys wasnt thinking about that.
Again thanks for all your help experts!!!
Actually you could keep this in a date field (because you need to track the date it went into the shop...)
So my original syntax still might be an option...
And also consider IrogSintas observation that a "DateOutOfShop" (or "DateCompleted") field may also be needed.
DateDroppedOff (ex: 1/1/2013)
DateInShop (ex: 1/3/2013)
DateOutShop (ex: 1/5/2013)
DatePickedUp (ex: 1/10/2013)
From these you can get any statistics you want.
So what is your one direct question here?
=DCount("*"," tblTempleFuelCellOnly","[U
Correction to your query.
=DCount("*"," tblTempleFuelCellOnly","[U
=DCount("tblTempleFuelCell
and I get ?error?
And fyed when i try your code
=DCount("*"," tblTempleFuelCellOnly","[U
I get an #error also
MODKitProduction.accdb
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Join our community and discover your potential
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.