Search results
-
S
Primary Key from main table to be ID in other tables
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... -
S
Primary Key from main table to be ID in other tables
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... -
S
IIF function question
Sum(IIf([Days Aging]>=21 and [Days Aging]<46,1,0)) That worked! Thank you all SO much! -
S
IIF function question
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...