473,664 Members | 2,995 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

using expression builder in Access 2003

1 New Member
Hi, I am trying to create a report on a table I have set up called ‘Outcomes’. I need to be able to do a count of all fields that have said ‘1’ ‘2’ or ‘3’ within a field name called ‘All outcomes’. I have tried using the expression builder but nothing seems to be working for me. Any ideas? Thanks in advance
May 10 '10 #1
1 2245
NeoPa
32,568 Recognized Expert Moderator MVP
In a header section (Page; Report or Group) you would add a control with the formula :
Expand|Select|Wrap|Line Numbers
  1. =Count(IIf([All Outcomes] In('1','2','3'),'*',Null))
[All Outcomes] would need to exist as a control in the Detail section of your report, and the underlying field would need to be of type String.

Welcome to Bytes!
May 10 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1344
by: Matt | last post by:
Has anyone tried to do an unattened install using the Package Wizard in the 2003 Developers Extensions? If so could you provide some basic information? Thanks in advance.
2
2359
by: shahla.saeed | last post by:
wat i want is to insert the calculated values(simple addition or subtraction) in fields of my table by using expression builders in my forms..i have made that feild in the table but still it doesnot store the paticular value in that field..plz help me out..looking forward for ur replys..thanx
2
1440
by: Darren Carter | last post by:
Does anyone know if it's possible to format data stored in an appSetting node when it's bound to a form control? I would like to format a date stored in appSettings, and I bind to it as follows: <asp:Label ID="SomeLabelID" Runat="Server" Text="<%$AppSettings:someDate %>" />
2
3165
by: Mark Reed | last post by:
Hi All, Using the instructions given from http://www.mvps.org/access/forms/frm0042.htm , I am trying to align 2 forms when the second form is opened. The problem I have is that when compiling the project, "Public Property Get Parent() As clFormWindow" throws up as "User-Defined type not defined" error. I have imported the class module from the web page. I'm guessing that I need to set a reference but do not know where to start :o(
3
10363
by: rrosynek | last post by:
I have a 2003 Access Database with several tables related in a one to many relationship with a parent I am looking to build a report which evaluates if different users of the table have all entered data properly. As an example - the parent table creates the customer account number, customer last name and customer ssn. A related table creates all other customer information including address, phone etc., another related table contains...
3
3172
by: gabry.morelli | last post by:
Hi everybody, I wanted to start an application using the MS Access 2003 Project, but as I create an .adp file it asks me to connect to a SQL Server. But I needed to create the dabase directly inside the adp project. Is that possible? If so, what's the procedure to create it? Thank you for your help.
3
2388
by: ALaurie10 | last post by:
Hi I have code below that enables a user to browse for an excel file, import the spreadsheet data, and dump it into a table . I keep receiving 3134 syntax error for "INSERT INTO" statement. Could someone please help me out? Also when I copy and paste this code into a module in a new database, I get an error message for the "Dim dlgPickFiles As Office.FileDialog" statement. I didn't get this error message in the old database, and don't...
1
4828
by: Bracciano | last post by:
Hello, I use the following VBA code to pick up PDF's from a folder and show it in an Access form. code: -------- Option Compare Database Public strImageFile As String Private Function GetImageFolder() As String
3
2490
by: Bruce | last post by:
I have a number of Access 2000 format databases on a Windows 2003 server. For some reason I can no longer compact these databases directly on the server using Access 2003. Access 2000 seems to compact them just fine however. If I copy the database to my local workstation Access 2003 will compact it just fine. On the server however, when I use Access 2003, it creates a compacted copy of the original database and names it dbn.mdb (where...
2
2860
pbala
by: pbala | last post by:
hello, I created the user level security for one MS Access 2003 database.It created one Shortcut file in Desktop. Now I want to share the database with my company workers. How i will share the Database? Thanks...
0
8348
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8861
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8778
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8549
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5660
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4351
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2764
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2003
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1759
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.