Start Date / End Date

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access2000, I have an invoice that is created as a form. Currently, you
are prompted to enter a date in the format that follows: July-2003. The
reult is that all the data from the month-year input calculates the data for
the invoice. The customer has requested that the invoice be sent bi-weekly
and not monthly any longer. I need to change the entry from July-2003 to
StartDate, End Date.

Can you please offer assistance as to how I can do this in a view?

Thanks in advance.
 
You can do a query that uses a between clause:

select * from invoices where invoice date between
startdate and enddate;
 
In Access2000, I have an invoice that is created as a form. Currently, you
are prompted to enter a date in the format that follows: July-2003.

What's the datatype of this field? Text? An Access Date/Time value is
actually stored as a floating point number, a count of days and
fractions of a day since midnight, December 30, 1899. As such it
corresponds to an exact point in time - July 2003 is not such a point,
but midnight, July 1, 2003 was.
The reult is that all the data from the month-year input calculates the data for
the invoice. The customer has requested that the invoice be sent bi-weekly
and not monthly any longer. I need to change the entry from July-2003 to
StartDate, End Date.
Can you please offer assistance as to how I can do this in a view?

Only if you can clarify the underlying table structure. What's being
entered where? How are the dates stored in the table?
 
Back
Top