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

 

[gmazza76]

The [NameField] can this be a Label with a persons name in?
As well as the [Status] aslo holding Open & Pended would i do another
=DCount("[Label1]", "[Data]","[Assigned To]='M' And [Status]='Pended' And [Status]='Open'")

thanks
Gav

 

[Norie]

No it has to be a field in the table.

By the way, why aren't you doing the count in a query?

 

[gmazza76]

I was advised as i needed to do it for around 5 people i would need to do it this way.
Can a query be run then shown as a report in figures instead of individual records.

If so i will look at doing it like this if it can give a total instead of individual records

Thanks

 

[Norie]

What exactly are you trying to do with the report?

 

[gmazza76]

I am hoping that when i open my database (or an individual) that the report will run automatically showing how many records are showing "open" or "Pended" under each of the 5 people that use it showing an upto date figure. Ideally i want the report to show and then hopefully build a few Macros in that will automatically run depending what info is needed.

I am hoping to make a landing page when it opens similary to how people do with Excel

Thanks
Gav

 

[Norie]

Gav

That should all be done in a query which you can then use as the records source of a report.