RE: add an integer to Date the get Date?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: BerHav (BerHav_at_discussions.microsoft.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 11:09:01 -0700

Hi,

This is sooo simple ;-) Add the credit term to the invoice date.
Just create a query and link both tables through the existing CustomerID - what I expect there is or any other unique identifier.

Create in your query an additional column like DueDate : InvoiceDate + CreditTerm

This works as Dates are nothing other than numbers for Access, Day 1 = 01/Jan/1900. Decimals are the hours, minutes and seconds. E.g. 0.5 = 12:00, 0.25 = 6:00 a.m. 

-- 
HTH
Bernd
"aa" wrote:
> I have a table "Invoices" containing, among other things,  the date of the
> invoice, as type Date
> I have another table "Customers" containing, among other things, the credit
> terms for each customer (like 30 days, 60 days etc) as type Integer.
> 
> How do I build a query to show the invoice payment due date, i.e. how do I
> add an integer to Date the get Date?
> 
> 
>

Relevant Pages

  • Re: Query
    ... product that shows the sum of all invoice amounts for a selected month ... and the sum of all Credit amounts for that selected month and the net ... Sum query for Invoices and append for all products (selected by ...
    (microsoft.public.access.forms)
  • RE: Query stopped working after entry 615 in table
    ... Macro Name: Find Jenish Invoice ... Table Name: Previous Invoices For Tracking ... How many records does Jenish Invoice Query pull? ...
    (microsoft.public.access.queries)
  • RE: Saving Form
    ... If it is a query, ... You HAVE the computer record of the invoice that you want. ... > everything we need to know about our inventory ex. ... >> would execute a report for the current record. ...
    (microsoft.public.access.forms)
  • Re: Workaround for Binding autonumber columns in a combobox
    ... set up the combobox and table in my form. ... I will use the example of creating an invoice. ... has a field for CustomerID. ... Its row source may be a query based on the customer table ...
    (microsoft.public.access.forms)
  • RE: Saving Form
    ... ok well the form is bound to a query where the only thing in it is the "in ... You HAVE the computer record of the invoice that you want. ... >> everything we need to know about our inventory ex. ... >>> would execute a report for the current record. ...
    (microsoft.public.access.forms)