You might try uploading a zip file containing the database. I thought that the expression I posted in my first reply would have taken care of 0 values. Does the following work better? FSC: IIf (Nz ( [on bill],0)=0, 0, Round ( [ex am1]/ [on bill],3))
Hello, I currently created a database for by job. With the database, information is entered to a Form, saved, and then is sent out via email to the appropriate parties involved. The datsabse is
Hello, Starting suddenly on 01/18/2017, after more than 1 year of successful Windows Update downloading and installation of updates, "Cumulative Update for Windows 10 Version 1607 for x64-based
I am building a Quality Assurance database. I have a form, with multiple combo boxes (all the same), which saves the following values to each field in the record: 5 - Compliant, 3 - Partially
A query will never "ignore" a date in a criteria, rather you haven't applied the correct format of the string expression for the date or, if a parameter, it hasn't been declared as DateTime.
You would, in each part of the UNION ALL query, return a literal string expression as a constant, e.g. "Psychiatric Medications", "General Medications" and "Brain Stimulants". You would then group the report first on screener and then on the column returning these constants.
I have a database that tracks flights of aircraft. The main table has the aircraft in it. I also have a subform that is linked back to the main form thru aircraft ID#.On the subform I would like for
