Forgot to add...If I remove the calculations the query is editable.

That is standard access behavior..

Yeah... you're making the query too complex to edit: Not Updateable

A running balance is too complex for access?  Seems simple enough Excel can do it with out blinking an eye. :)  Trying to replace quicken.

Sure, you can do it in a query and you can do it in a form as well in Access, but you're just making the query too complicated in order for it to still be editable, which is why, in my running balance example, I do it in a continuous form.

Access Expert 29 covers it.

Maybe I overlooked something in our message, but I just want to share my thoughts. Richard, your teaching style is great; you understand Access really well, maybe even better than some Microsoft devs.

I joined to learn from you and others, but my recent post left me feeling lost. I spent all day searching online and using tools like GPT, but I still don't fully get it.

For example, I wanted to make a continuous form for calculations, but without an editable query, it wouldn't work. So when you said "I do it in a continuous form," it didn't help much.

I'll keep watching your videos, but I hope for more detailed answers from you and the moderators. If that's not what this forum is for, I'll stop asking. Thanks for the learning space.

David, I told you exactly which course covers that topic in detail. This forum is here to help you understand my videos and learn Access, but I'm not going to reinvent the wheel if I already have a lesson that explains what you want to know.