Start Date / End Date

[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.

 

[Lucas]

You can do a query that uses a between clause:

select * from invoices where invoice date between
startdate and enddate;

 

[Fredg]

Change the parameter to:

Between [Enter Start Date] and [Enter End Date]

 

[John Vinson]

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?