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.