UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> What Is Error This Function, Office 2007    
 
   
azhar2006
post Apr 5 2012, 05:48 AM
Post #1

UtterAccess Addict
Posts: 253

What is error this function
I want to collect 'Manager' + 'Assistant'

=DCount("*";"az";"rtba='Manager'+'Assistant' And mort='Permanent'")
Go to the top of the page
 
+
cheekybuddha
post Apr 5 2012, 06:10 AM
Post #2

UtterAccess VIP
Posts: 5,485
From: Brixton, front line
Hi,

Not sure quite what you're after, but at a guess you could try:
=DCount("*";"az";"(rtba = 'Manager' OR rtba='Assistant') And mort = 'Permanent'")

hth,

d
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 06:21 AM
Post #3

UtterAccess Addict
Posts: 253
Also error
Go to the top of the page
 
+
arnelgp
post Apr 5 2012, 06:39 AM
Post #4

UtterAccess Ruler
Posts: 1,090
CODE
=DCount("*";"az";"(rtba = 'Manager' OR rtba='Assistant') And mort = 'Permanent'")


replace the semicolon with comma.

=DCount("*", "az", "(rtba = 'Manager' OR rtba='Assistant') And mort = 'Permanent'")

This post has been edited by arnelgp: Apr 5 2012, 06:39 AM
Go to the top of the page
 
+
MiltonPurdy
post Apr 5 2012, 06:41 AM
Post #5

UtterAccess Ruler
Posts: 1,621
From: Arkansas
No semicolons ((IMG:style_emoticons/default/wink.gif) , commas

Dcount("*","az", etc
Go to the top of the page
 
+
cheekybuddha
post Apr 5 2012, 07:00 AM
Post #6

UtterAccess VIP
Posts: 5,485
From: Brixton, front line
Ah yes! Use commas instead of semi-colons! (IMG:style_emoticons/default/wink.gif)

(Thanks arnelgp and Milton (IMG:style_emoticons/default/thumbup.gif) )

d
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 07:08 AM
Post #7

UtterAccess Addict
Posts: 253
Hello arnelgp /MiltonPurdy
I get an error message
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 07:11 AM
Post #8

UtterAccess Addict
Posts: 253
Thanks arnelgp
Example you have
Try it and see the error message
Go to the top of the page
 
+
arnelgp
post Apr 5 2012, 07:13 AM
Post #9

UtterAccess Ruler
Posts: 1,090
Azhar copy and paste the code above.
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 07:18 AM
Post #10

UtterAccess Addict
Posts: 253
This is the database
Yes, I copied the function to not work
Attached File(s)
Attached File  report.zip ( 143.97K ) Number of downloads: 4
 
Go to the top of the page
 
+
arnelgp
post Apr 5 2012, 07:28 AM
Post #11

UtterAccess Ruler
Posts: 1,090
I tried it I did not see any error, its working here.
Check maybe your keyboard, change it to english not arabic.
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 09:33 AM
Post #12

UtterAccess Addict
Posts: 253
Yes I use the English language
Please Sdbaka arnelgp
Help
Go to the top of the page
 
+
arnelgp
post Apr 5 2012, 09:43 AM
Post #13

UtterAccess Ruler
Posts: 1,090
Which part is it? Is it on the report we fix yesterday?
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 09:53 AM
Post #14

UtterAccess Addict
Posts: 253
Yes exactly
Professorial dear
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 10:02 AM
Post #15

UtterAccess Addict
Posts: 253
Sorry
LGBT for you shortly before the power outage for two hours
But the issue in another forum under the title of ((This Example Described The Report))
Another two facilities with us
Go to the top of the page
 
+
arnelgp
post Apr 5 2012, 10:04 AM
Post #16

UtterAccess Ruler
Posts: 1,090
Here take a look.
Attached File(s)
Attached File  report.zip ( 154.13K ) Number of downloads: 8
 
Go to the top of the page
 
+
azhar2006
post Apr 5 2012, 10:15 AM
Post #17

UtterAccess Addict
Posts: 253
Thank you very, very arnelgp
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 05:41 AM