Search results

My results are not right with that method. But I will continue to tinker around with this until I get what I need. I thought I could use an expression like Assigned Tiers: IIF([Processor]="",sum([Tiers]),0) - Thank you though

The query works just fine (missing brackets are just a typo on my end) but I need an expression for Assigned Tiers. I need a query that will give me the sum total of Tiers, regardless of who the Processor is and a sum total of Tiers who have been assigned a Processor. That's where I am having a...

I need help with an expression. I need a expression to calculation the total Tiers that have been assigned a Processor. I know I can use the following query but I have other calculations that don't need the exclusion of the Processor to be part of the overall query. And I thought I could use an...

You rock. That worked. Thank you.

No, I am querying a comments field so I want records that include #Variance in the comments field.

Hello, I'd like to query #Variance in an access database. I have the Like'*[#]*' but I can't seem to incorporate the variance to that. Can someone please help me with that? Thanks

Hello: I am hoping someone can help me. I have a subform on the MainForm and a Print button. I'd like the print button on the MainForm to open a report when a record is selected on the subform. - Thanks in advance.

User error issues on my end. That works perfectly. Thank you.

So I have an end_date of 02/17/2017 and I expected to see a start_date of 1/1/17 but it's showing blank. I also have a start_date of 3/15/2017 that isn't showing.

Let me try to write it out: IF start_date is greater than or equals to 1/1/2017 then return the start_date. And if the end_date is greater than or equals to 1/1/2017 return date of 1/1/2017 or leave it blank. I hope I have cleared out any confusion.

Can someone please help me out with an IIF statement - Essentially I want start date to be blank if the ending date is prior to 1/1/2017; start date to populate is start date is after 1/1/2017 and to be 1/1/17 if start date is prior to 1/1/17 and ending date is after 1/1/2017. I started out with...