troubleshooting Question

Adding total dates in a text box

Avatar of gigifarrow
gigifarrow asked on
Microsoft Access
15 Comments1 Solution259 ViewsLast Modified:
I have a table called "tblTempleFuelCellOnly".
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","[Unit] = ('FY10')")-Nz(DCount("[Unit] IN ('FY10' ]"," tblTempleFuelCellOnly"))

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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros