Expression Builder Query

[gmazza76]

Good Afternoon,

I am trying to get a "Textbox" to give a total if the "assigned to" = "M" and Status = "Pended" as per below.

=[Data]![Assigned To]="M" And [Data]![Status]="Pended"

I am getting an error as #Name?.

I am unsure of where i am going wrong or is there an easier way to do this?

Thanks
Gav

 

[BrianMH]

What is assigned to and pended? Are they also text boxes? What are you trying to total? Try to give us more detail about the form, the data and what exactly you want to do. We don't know anything about your database and it isn't very clear what you are trying to accomplish.

 

[sheetspread]

What do you have set under the text box Properties, Control Source?


It looks like you need an IIf and condition(s) in the expression also.

 

[gmazza76]

Ok, I will give it a go as best i can.
"Assigned to" is the header to the column that holds the persons name i want to count in the database
"Status" is the header to the column that holds the status of the record (Pending / Closed / Open)

I want to count how many records have the name in the Assigned to and Pended or Open in the Status column.

I have a textbox on my report with the agent name next to and would like to be able to show the number next to it.
In the text box proerties i have

=[Assigned To]="Mark Taylor" And [Data]![Status]="Pended"
**Data is the table the info is in
as the contol source.

Idealy I would like to be able to show on my report:-

Gavin Mazza 10 open

I hope this makes sense.

Thanks
Gav

 

[sheetspread]

Sounds like you need a dcount formula

 

[gmazza76]

How do these work as i was trying to read up on it and didnt really understand it

 

[Norie]

Perhaps.

DCount("[NameField]", "[Data]","[Assigned To]='M' And [Status]='Pended'")

 

[gmazza76]

Perhaps.

DCount("[NameField]", "[Data]","[Assigned To]='M' And [Status]='Pended'")

Afternoon,

What is [NameField]?

Thanks
Gav

 

[Joe4]

Have a look here for details/explanations on the DCOUNT function: MS Access: DCount Function

 

[Norie]

[NameField] is the field with name of the person you want to do the count for.

I have no idea what that field is called so I used [NameField], you'll need to replace it with the real name.