 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / November 2006count only if criteria in another field is met
Can I Count (the report footer) based on criteria in other fields, sort of : count if [Team] = Trim and [Status ]= red I have tried many different combinations to get this to work or do I need to create queries for this . I have 15 different teams which could have one of four different Status's total neophyte would be grateful for suggestions thanks Try this -- Sum(IIF([Team] = "Trim" And [Status] = "red", 1, 0) Trim and red need to be in quotes as they are text. This evaluates team and status and gives a value of 1 (one) if true and then sums the results. > Can I Count (the report footer) based on criteria in other fields, > sort of : count if [Team] = Trim and [Status ]= red [quoted text clipped - 3 lines] > total neophyte would be grateful for suggestions > thanks thanks for the quick answer - I did try this in the report footer, however when I went to print preview I got an error message'Syntax error in query expression'. I double checked the way I entered the formula and added an = to the beginning and still got an error > Can I Count (the report footer) based on criteria in other fields, > sort of : count if [Team] = Trim and [Status ]= red [quoted text clipped - 3 lines] > total neophyte would be grateful for suggestions > thanks Post the SQL of the query for your report. > thanks for the quick answer - I did try this in the report footer, however > when I went to print preview I got an error message'Syntax error in query [quoted text clipped - 8 lines] > > total neophyte would be grateful for suggestions > > thanks Huh? , where would I find that? > Post the SQL of the query for your report. > [quoted text clipped - 10 lines] > > > total neophyte would be grateful for suggestions > > > thanks I am assuming that your report is based on a query. Open the query in design view, click on menu VIEW - SQL View. This opens another window. Highlight, copy, and paste in a post. > Huh? , where would I find that? > [quoted text clipped - 12 lines] > > > > total neophyte would be grateful for suggestions > > > > thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.