Expression in Access "Reports"

I have a field in my table called [Sale Type].  There are 3 different choices 
for this field: "Retail", "Wholesale" or "Warranty Only".  I'm trying to 
build an expression in my report that counts the number of records in that 
field, but excludes "Warranty Only" entries.  I'm using =count([Sale Type] = 
"Retail","Wholesale").  I get an error saying "The expression you entered has 
a function containing the wrong number of arguments".  Access 2007.

2/4/2010 2:41:01 PM
access.reports 4434 articles. 0 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 41

    =-Sum([Sale Type] <> "Warranty Only")

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -
Reply to group, rather than allenbrowne at mvps dot org.

"Reese" <> wrote in message
> I have a field in my table called [Sale Type].  There are 3 different 
> choices
> for this field: "Retail", "Wholesale" or "Warranty Only".  I'm trying to
> build an expression in my report that counts the number of records in that
> field, but excludes "Warranty Only" entries.  I'm using =count([Sale Type] 
> =
> "Retail","Wholesale").  I get an error saying "The expression you entered 
> has
> a function containing the wrong number of arguments".  Access 2007. 

2/4/2010 2:55:24 PM
Use one of the following

=Count(IIF([Sale Type] in ("Retail","Wholesale"),1,Null))

=Count(IIF([Sale Type]="Warranty Only",Null,1))

=Abs(Sum([Sale Type] <> "Warranty Only"))

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Reese wrote:
> I have a field in my table called [Sale Type].  There are 3 different choices 
> for this field: "Retail", "Wholesale" or "Warranty Only".  I'm trying to 
> build an expression in my report that counts the number of records in that 
> field, but excludes "Warranty Only" entries.  I'm using =count([Sale Type] = 
> "Retail","Wholesale").  I get an error saying "The expression you entered has 
> a function containing the wrong number of arguments".  Access 2007.
2/4/2010 3:21:18 PM

Similar Artilces:

Access reports 04-01-07
I have check boxes in an Access report. I am exporting the report as an rft file. When I do this, the captions for the check boxes show up, but the boxes themselves disappear. Is there some way to fix this problem? Thanks I assume you mean rtf and not rft. An answer given by Allen Browne on the subject: None of the graphical elements survive when you export in RTF (Word) or TXT (text) formats, so you lose the lines, check boxes, pictures, etc. If the recipient does not need to edit the report, you could use Snapshot format. The snapshot viewer is a free download for them: http:...

Difference between XML templates and Active Reports
Why does RMS use XML templates (for receipts and P.O.s) and for most other reports Active Reports? I realize that the XML receipts can not be changed or resorted on the preview screen, but why use not all active reports? Active reports are based on formating the results of a SQL Query - if you can work out the SQL to get the result set you want, you can create almost any report you want. The XML Templates are based on objects internal to RMS, like the current transaction for reciept printing, the active PO or Transfer request for PO prining, or a given customer for Statements. Y...

Quarter-End Payroll Reports #2
When trying to process quarter end payroll reports I am receiving and unhandle script exception: [Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored procedure 'SCSB.dbo.uprGetPension'. ...

Custom reports, where are the .rdl's found?
I've created a dozen or so custom SRS reports and imported them via the Reportserver. Now, I'll be moving to a new report server and am unable to "extract" my .rdl files (yes, I know, stupid that I didn't keep the originals). Are these held somewhere in the report server or on the web server? I was able to find where the vanilla ones are saved to my custom ones aren't there. I don't want to rewrite them unless absolutely necessary. More Actions did not work either. Thx. Not sure why the 'More Actions/Download report' doesn't work, but the ne...

e-mail 2 reports
Is it possible to email 2 reports as 2 separate attachments? With outlook as an email client: -- Arvin Meyer, MCP, MVP "Samuel" <> wrote in message news:%23fzywcCtHHA.4236@TK2MSFTNGP05.phx.gbl... > Is it possible to email 2 reports as 2 separate attachments? On Jun 21, 2:07 pm, "Arvin Meyer [MVP]" <> wrote: > With outlook as an email client: > >

Deployed SQL Reports
I am trying to deploy the GP SQL reports. I have assigned the user to the database, but it appears they do not have proper access. I am getting error messages like the following: • An error has occurred during report processing. (rsProcessingAborted) o Query execution failed for data set 'dsPrmLocation'. (rsErrorExecutingCommand)  Semantic query execution failed. The SELECT permission was denied on the object 'InventoryPurchaseReceipts', database 'TEST', schema 'dbo'. (rsSemanticQueryEngineError) Any suggestions? Thanks! Craig If you are referring...

Mailbox Manager and "Report only" summary reports are wrong
I've just started utilizing the mailbox manager on out win2k3/Exchange 2k3 sp2 server. I created a Mailbox Policy to "REPORT ONLY" and send a summary report to the administrator. Every time the mailbox manager runs and does what it is supposed to, but the Summary report that is sent to the administrator is wrong. It always reports a Messages Moved # and Size of Messages Moved # With values greater than 0. Now I know that it is not actually moving anything because the same wrong values keep coming up every time. Of course my question is, How do I get a corrected report? T...

RDC Crystal Reports integrated problem
I use Report Designer Component (RDC) in my program to allow user modify reports. I downloaded RDC Merge Modules for Crystal Reports XI Release 2 from BO. It is the zip file contains 4 files: * CrystalReports11_5_RDC_Designtime.msm * CrystalReports11_5_RDC_License.msm * CrystalReports11_5_RDC_Reportengine.msm * CrystalReports11_5_RDC_Runtime.msm I made a build and install but I got the error about license. So, I try to add all 4 merge modules and use the install serial (I bought the Developer Edition) for keycode property of CrystalReports11_5_RDC_License.msm. Unfortunately, ...

Copying Advanced Financial Reports Into Another Company
I am on version 9.0 and I created some financials in the Advanced Financial reports area, but I would like to use the same layout and customization for the other entities we have in Great Plains. Does anyone know how to do this? I am really trying to avoid having to recreate the same reports for every individual entity. Thanks in advance There is a tool on CustomerSource that lets you copy Advanced Financial Reports from one company to another. On the left side of CustomerSource click on Support >> Automated Solutions. -- Japheth Nolt Microsoft SBF Specialist Landis Computer www....

print multiple reports from database
Hi I have a table in my database that contains customer orders, within those orders are the products reuired to fulfil the order. For each product there is a related product information guide (in pdf) stored in a folder on my computer. Is it possible to run a query/report that prints the requires information sheets, for each customer order? (also posted in microsoft.public.access.queries) Regards Alec Use the Sorting and Grouping to force a new page for each group. -- Build a little, test a little. "alecgreen" wrote: > Hi > > I have a tab...

Customising monthly reports?
Hello, I'm just starting out using Money. One thing that's annoying me is that I can't see how to customise the monthly report. I have income and expenditure from a small business which I don't want to see on this report. I've removed the relevant categories from other reports, but I don't seem able to do it on the monthly report, and consequently the figures are skewed and pretty much useless to me. I'm I stuck with this? Cheers! Martin Pretty much. <> wrote in message news:1175465343.267759.95030@p15g2000hsd.googlegroups.c...

Printing crystal reports invoices?
I am looking at a GP install that a user tried to upgrade to version 9 themselves (from 8). apparently in 8 they had an option to print invoices in crystal.. when they printed the invoice they had an option in the print menu dropdown to print to crystal. apparently it was configured somehow using the named printers setup. Is anyone familiar with this? The user has absolutely no idea whether or not they had any third party apps installed and from what I believe is their v8 dynamics.set file I don't see any additional modules that would do this. ideas? thanks Are they using the Forms Pri...

Crystal Reports 10 Licensing
At Convergence, I spoke to the people at the Crystal booth and the impression was that the pricing structure had changed substantially and now the bulk of the expense is with the licenses to view the reports as opposed to the licenses to write the reports. Do you have any pricing details for the latest version of Crystal? I've developed a application that uses Crystal's API calls to deliver reports on a citrix server and that eliminates to have user licenses. >-----Original Message----- >At Convergence, I spoke to the people at the Crystal >booth and the i...

Installiang the Crystal Reports add-on to a workstation
Hi, one of my colleagues is trying to generate custom crystal reports for CRM. He has installed Crystal Reports v9.0 + SP3 which makes his version When he attempts to install the CRM Crystal addon piece (CD5) he gets an error message referring to "Setup has detected that you have Crystal Reports 9.2.0 installed. You must first upgrade to Crystal Reports 9.2.2 to continue with this setup." We are not sure what is causing this message. Can anyone help? Thanks, Perry You can download the appropriate version of Crystal Reports 9.2.2 from the Business Objects Web s...

Unrealized Capital Gains Reports
This is a new problem. When I sell a partial lot of a given stock, and refresh the "Portfolio Value by Account or Investment" report, the cost column doesn't change to reflect the lower share count. Here is a specific example: Have 200 share of xyz at a cost of $20/share. Prior to selling a partial lot, the report gives the correct unrealized gain information with a total cost of $4,000. When I sell 50 shares, and refresh the report, the cost column stays at $4000 and recalculates the unrealized gain of the remaining 150 share as if the remaining shares were at a co...

Unable to Access Reports from CRM Interface
We have deployed Microsoft CRM, but there is problem that the reports cannot be accessed by using Microsoft CRM interface from client's machine. There is no problem accessing the report in local server, it can be shown correctly from CRM interface, if it's accessed in the CRM server/database server. There are two servers, one for CRM application and the other for database+report server. User can access the Report Manager interface from their local machine (http://dbserver/reports). Anyone has idea, what is the possible error? Thanks. there is a white paper that requires additional ...

Documenting Smartlist Reports beyond report name
Is there a way to document within GP further information about smartlists. I would like to be able to write a 2 or 3 sentence explanation of the uses of the report, etc. that would be readily available such as in a report properties but I don't see any such capability. ...

I was wondering if anyone new how to generate a simple report. Daily Sales, showing just day and total sales for that day.... for a month Ive tried, but no good results...? Do you need detailed sales or just the basic dollar figure? Manager> Report> Sales> Summary sales --choose filter or Manager> Report>Sales>Detailed sales -- Elizabeth M. "cjones" <> wrote in message >I was wondering if anyone new how to generate a simple report. Daily >Sales, > sho...

Top 5 Most Important Reports
Hi, I was wondering ( based on ALL of your experiences) if you could share the top 5, lets say, reports that people want to see or know about from the Project Manager? And I understand that different stakeholders are going to want different things and that no one organization is the same. However, I have to guess that there have to be "Best Practice" methods for reporting project information right? Thanks for your help. -jp Earned Value Reports (includes PV, EV, AC, SPI, CPI and their variances) Critical Path & Total Slack Analysis Poor performing tasks ba...

One user unable to see reports
Hi, I'm wondering if anyone else has encountered this problem - a user is unable to view reports. Going to Workplace->Reports results in the "Server Error in '/' Application." error message. Sometimes the records page does load, but the list of reports is empty. Also, context sensitive reports don't show up in their regular places - in fact the reports button is completely gone from the forms that usually have it. I've tried other user logins and they have no problem viewing reports. Only this particular user has the error. Reports has been working for t...

log of printed reports
I have a set of reports that I print on a regular basis. I need to be able to keep a track of the date and time at which each report was printed in a table of query so if it goes missing, i have a record of whether and when it was printed. I have been unable to come up with a way in which i could generate this automatically. I would be thankful if i could be helped with this. Thankyou, Radhika Create a table with columns ReportName and PrintedDate. Let's assume you name the table ReportLog In the Close event of each report, put code like: Dim strSQL As String If MsgBox("Did...

How to backup reports created using SQL Reporting Services?
Can anyone please tell me how do I take backups of reports created through SQL Reporting Services (SSRS). Does anyone have documentation on procedure of backing up reports created with SQL Reporting Services? Also does anyone have steps on how to restore reports from backup? I have been assigned task to modify some reports using SQL Reporting Services. It is my first time working with SSRS reports, so I want to be sure to take a good backup of all the reports created so far using SSRS and I'd like to be able to know how to restore a report from backup in case something goes wrong....

Verify Database (Crystal Reports)
We are tryhing to add selected custom fields to existing crystal reports on CRM Version 1.2. We are running Crystal Reports Developer Edition 9.2.2+. Any changes we make to existing rpoerts data, structure, formula, etc work fine. The problem is we can not verify the database in order to grab our custom fields. "Failed to load database information". Can we not use the Developer Crystal Version to add custom fields ? JRM 9.2.2+ ??? can you go to database verify database location and make sure the location says SSO rather than a server name -- John O'Donnell Microso...

Crystal Reports and Memo fields
Is it possible to use Memo fields to filter Crystal Reports? Scenario: We are using the description field on the account level to store marketing campaigns that the account has been sent. I now want to be able to filter the opportunity reports to display information on each marketing campaign, so I want a filter which says something like 'Description contains "MKT-01"' where MKT-01 is the name of the marketing campaign. Each account can potentially be involved in multiple (100's) of different campaigns, which are listed in the description field. Any ideas woul...

cannot access reports on crm web
hei, i am running crm 3.0 system. i am able to see and run reports on outlook client of crm but not on web. is there anybody else who has encountered same problem or can anybody please recommed a solution to my problem. thanks RG in the web client can you go to crmwebserver/reports and see a list of reports? ======================= John O'Donnell Microsoft CRM MVP "RG" <> wrote in message > hei, > i am running crm 3.0 sys...