Recent content by smithjp4

Thank you so much for your quick reply...however...this doesn't exactly help... Perhaps I didn't explain properly. In the forms, themselves, if record 9 in frmMain is active, and record 9 also has had information entered in frmFiscal and frmAccountingLine, then clicking the buttons to...

I am building a database in Acess 2007 and I have three tables housing data...one table houses the main data, one houses fiscal data and the third houses accounting line data. tblMain has a primary key set to auto number, tblFiscal and tblAccountingLine both have their ID field set to number...

Sum(IIf([Days Aging]>=21 and [Days Aging]<46,1,0)) That worked! Thank you all SO much!

Hello everyone, I’ve created an accounts payable database where we can track invoices by the amount of days each invoice is aging, the amount of the invoice and the organization that we’re paying the invoice for. I’m now trying to create a query that will give a dashboard snapshot showing the...