Search results

I have two formulas that seem like they should work, but have something wrong. I'm guessing it's a syntax problem, but can't for the life of me figure it out. This one doesn't give me an error, its just blank: =Count("[QueryName]![QueryField]='String'") This one gives me an Error. It's...

Can I sum a query in a report? In my report, I tried the below and got an error. DSum("[QueryName]![Field1]","[QueryName]","[QueryName]![Field2]=Value") Thank you in advance.

I learned not to do calculated fields in a table, so I'm trying to build the Query. I need a lookup based on 4 attributes. A number value is designated per row based on the 4 attributes. I need to get that number. Below are my two expressions. The first works, the second doesn't. Expr1...

Hello, I'm new to Access and having trouble with some (I would assume) basics. I have a table with a few Listbox options. I want one of the columns' values to be determined by the value chosen in another field. How do I do this? Example: In column A I choose value ABC from the dropdown. I...