473,508 Members | 2,390 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 2235
NeoPa
32,557 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
1330
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
2351
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...
2
1435
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: ...
2
3153
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...
3
10358
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...
3
3165
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...
3
2381
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...
1
4822
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...
3
2479
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...
2
2855
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...
0
7224
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7120
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...
1
7039
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...
0
7494
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4706
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...
0
3180
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1553
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 ...
1
763
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
415
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...

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.