Recent content by bellis

Both are in the Details section of a Report. I tried separating the functions and can't even get a =SUM([Field]) to work. I tried changing the font color to make sure it's not white. I tried quote marks everywhere you can imagine. I tried =SUM([QueryName]![Field]), also with and without...

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...

I still can't get it. Probably a syntax issue, as you said. I tried copying the syntax from the link you sent. Any ideas? I'm stumped! =DSum("[QueryName]![Field1]","[QueryName]","[QueryName]![Field2]='String'") This is possible to do on all Query fields right?

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...

Thanks this worked like a charm! I'm having one problem still with the Requery portion. What is "Me."? Should that reference something in my file? Its not refreshing after the update.

Thanks! Already a huge help! Do I need separate tables for my data? ie a NY table with cities in NY, a NJ table with cities in NJ, etc. Or can they all be in the same and referenced via a column title?

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...