I have a problem with a module I wrote. At a specified set time, the code was supposed to print 2 differet reports. Sometimes one of the report doesn't have any data so it is suppose to skip that report and just print the other report (I set Cancel = true in the NoData event for both of those...
I have a parameter query asking the user to enter an Invoice Number. My parameter query is as follow:
Field: InvoiceNum
Table: Invoices
Criteria: In (select top 1 [InvoiceNum] from Invoices where [AccountNum]=[Customers].[AccountNum] and [InvoiceNum]<[Enter Invoice Number] order...
I’m trying to create a database that will automatically bill each customer on a monthly basis for services provided by our company.
I have 3 tables: The CUSTOMERS table with Customer ID (primary key), Name, Address, Telephone, etc.; the INVOICES table with Invoice Number (primary key)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.