Friday, February 01, 2013 3:24 PM
I have created a database for my work and now at the end of month reports are due. I have made all the queries and everything is working great. But, my boss now wants a number that I dont know how to write the expression for. Here is a bit of background. It is for the EMS medical at a casino. So this is from a medical report. I have two yes/no boxs. One is for employee and one is for office visit. I need to be able to come up with a monthly total if an employee came in for an office visit. This is what I came up with but of course it doesn't work. Any help would be greatly appricated. I am using MS Access 2207
IIf(sum(Abs(([run info].[Employee],[run info].[office]="yes", null))) as [Employeeoffice]
Friday, February 01, 2013 7:40 PM
First, this is a forum for SSAS = SQL Server Analysis Services; not for relational database, not for MS Access and not for reports. You should post your question to a more related forum.
And just by your verbal description I don't understand your requirements. You should add the table design, some sample data and the required result to your post.
Olaf HelperBlog Xing
Friday, February 08, 2013 4:09 AMModerator
Thanks for your post.
We discuss SQL Server Analysis Services related issue in this forum. In your case, I suggest you post your question in Office 2010 - IT Pro General Discussions forum.
TechNet Community Support