If function with Vlookup
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hello... I am currently building database for my July and August customers.
Because I am doing a promotion, those that purchased in July will be able to
get a free course in August. I would like to know how do I build it so that
in the "Amount" column, it would search July data and if the customer number
corresponds then it will return the invoice number in July (which is set up
next to the "Amount" column) and if cant find the customer number, then it
should display "100".
.
Relevant Pages
- Re: Rate Customers by Invoiced this Year Field
... a negative amount in the "Invoiced This Year" field. ... Dim dbAny As DAO.Database ... rank each customer should receive. ... Is it based on a customer's percentage of total company invoices? ...
(microsoft.public.access.modulesdaovba) - Re: Charge for not paying by DD
... The difference with a or DC SO is that it is easier for the customer to ... credits the internal account with the amount as being 'paid' at the same ... The account is then debited if the DD bounces, ... So what exactly is the extra cost. ...
(uk.legal) - Re: Adding numeric value to a text "Value list"
... let's look at a simple Customer Order system. ... Customer, Order, LineItem, Inventory, Payment ... BalanceDue, a numeric calc field, total order amount minus total payment ...
(comp.databases.filemaker) - Re: Adding numeric value to a text "Value list"
... let's look at a simple Customer Order system. ... Customer, Order, LineItem, Inventory, Payment ... BalanceDue, a numeric calc field, total order amount minus total payment ...
(comp.databases.filemaker) - Re: Creating auto loan database
... I would consider a form and a subform ... The main form would allow you to select the specific customer ... calculate the total amount paid by adding the two fields' data together. ...
(microsoft.public.access.forms) |
|
