Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
sql question

Domanda sql question

  • Friday, February 01, 2013 3:24 PM
     
     
    Sign In to Vote
    0

    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]

     

All Replies

  • Friday, February 01, 2013 7:40 PM
     
     
    Sign In to Vote
    0

    Hello,

    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 Helper

    Blog Xing

     
  • Friday, February 08, 2013 4:09 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi RSC,

    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.

    Regards,
    Bin Long

    Elvis Long
    TechNet Community Support