Thank you. I got myself so wrapped up in trying to write it from scratch that I forgot to take advantage of what Access has to offer.
Obviously, the query is returning exactly what I need now.
I know that what I have been asked to do is not that difficult. I am just stuck and can't figure it out. So I am sure the people here at Access World can help me.
I have 2 related tables:
Payments:
InvoiceNum
Date
PaidAmount (Note can be positive or negative amount)
VendorID - links to...
Can I tag onto this thread and ask for basically the same question? I am not getting a solution from the answer provided here.
It was said that a button on the subform can be used. Problem is, I see no way to display the form in any way other than datasheet. Even if I define the subform to...
Thanks for the reply. I need to read parts of it a little more carefully. I understand the basics of it though. Part of it I had already figured out since making this post. Part of it might make what I have tried a little better.
Unfortunately I have to wait till Monday to try any more. I...
I have a SQL Server database along with all of its associated stored procedures. I am trying to use Access (2003) as a project, to create a front end to the database. If I simply execute one of the shown stored procedures that requires parameters, it asks me to input them.
I want to create a...