Search results

I have the following tables and their fields: Accounts -> AccountID, AccountName, BrokerID, Starting Value Brokers -> BrokerID, BrokerName Credit Spreads -> TradeID, AccountID, BrokerID, NetPL, TotalInvestment, NetROI Reverse Scalps -> TradeID, AccountID, BrokerID, NetPL, TotalInvestment...

...I must be stupid. Your revision is working, but I still don't see why. :o About #1) I did the query as a last resort before I responded here and uploaded the database just to see if I could get that method to work. I left the fields where I attempted the query version as they were out of...

Actually, none of my controls are named the same as a field in the table. They are all named either txtInsertFieldNameHere, or the default from a copy and paste action which seems to be Textnnn, where nnn is some incrementing 3-digit number.

Bob, I initially did link it to the field. It worked in layout view. I switched to design view, added the rest of the fields I wanted summations for, and then came back to layout/form view and everything was fubar. This works in a textbox in the detail section: =[MaxRisk] This does NOT work...

I am away from my laptop at the moment. Replying via my phone. I'm not sure what you'd like me to show. The text that's written into the textbox control source property us written something like this: [CreditSpreadsSummation]![Sum of CreditReceived] That's the best I can recall from memory...

Sorry guys, that didn't help. I'm fairly confident I've not named anything improperly and the compact and repair/export idea didn't work. I decided to change the way my table was made. I was just going to calculate the data for display purposes only but that was proving to be too :banghead...

I've been working on a multi-item form. I've put several hours of work into it. Everything was working just fine until suddenly, after minimizing the database to go work on an expression in notepad, I come back and find that every single one of my calculated unbound fields is showing "#Name?"...