Date comparison :: Original price vs Reduced price :: Access 2000/ASP

[jason]

I need some guidance in how to control dates with regards price reductions
in my product list inside an Access 2000 database.

For instance:

1. I will start off with an ORIGINAL PRICE where I must record the data
capturers INSERTION date

2. At some point there may be a REDUCTION IN PRICE. I need to record when
the data capturerer modified the record to reflect the new price.

....I then will dynamically compare the two dates to determine if there has
been a price reduction.

What would be the best way to go about comparing the original insertion date
and a later modification date for the two price fields: original and
reduced.

It appears to me that I cannot use Date () as this would auto. insert a date
into the modified price date field when the data capturer firsts imserts the
ORIGINAL PRICE.

I could allow the data capturer to select the two dates but this allows for
input error or incorrect date selection.

I appreciate your replies - thanks In advance

- Jason

[James Brown]

Hi,

Are you trying to do this in a table view? Or are you doing this on a form
/ in code? I don't think you can provide functionality such as "Date
Modified" in a table view, but if you were using a form it would be very
easy.

ASP is a programming language for the web, so you'd be best to ask in an
access specific group like microsoft.public.access.formscoding

Jamie.


"jason" <jason@catamaranco.com> wrote in message
news:uy0Ef0lRDHA.2188@TK2MSFTNGP10.phx.gbl...

> I need some guidance in how to control dates with regards price reductions
> in my product list inside an Access 2000 database.
>
> For instance:
>
> 1. I will start off with an ORIGINAL PRICE where I must record the data
> capturers INSERTION date
>
> 2. At some point there may be a REDUCTION IN PRICE. I need to record

when

> the data capturerer modified the record to reflect the new price.
>
> ...I then will dynamically compare the two dates to determine if there

has

> been a price reduction.
>
> What would be the best way to go about comparing the original insertion

date

> and a later modification date for the two price fields: original and
> reduced.
>
> It appears to me that I cannot use Date () as this would auto. insert a

date

> into the modified price date field when the data capturer firsts imserts

the

> ORIGINAL PRICE.
>
> I could allow the data capturer to select the two dates but this allows

for

> input error or incorrect date selection.
>
> I appreciate your replies - thanks In advance
>
> - Jason
>
>

[jason]

Hi James - yeah I just clicked that I could use ASP to control the later
DATE MODIFIED aspects while allowing Access to control the initial DATE OF
INSERTION via Date().....


"James Brown" <nospam@nospam.com> wrote in message
news:#$14gjvRDHA.2196@TK2MSFTNGP11.phx.gbl...

> Hi,
>
> Are you trying to do this in a table view? Or are you doing this on a

form

> / in code? I don't think you can provide functionality such as "Date
> Modified" in a table view, but if you were using a form it would be very
> easy.
>
> ASP is a programming language for the web, so you'd be best to ask in an
> access specific group like microsoft.public.access.formscoding
>
> Jamie.
>
>
> "jason" <jason@catamaranco.com> wrote in message
> news:uy0Ef0lRDHA.2188@TK2MSFTNGP10.phx.gbl...

> > I need some guidance in how to control dates with regards price

reductions

> > in my product list inside an Access 2000 database.
> >
> > For instance:
> >
> > 1. I will start off with an ORIGINAL PRICE where I must record the data
> > capturers INSERTION date
> >
> > 2. At some point there may be a REDUCTION IN PRICE. I need to record

> when

> > the data capturerer modified the record to reflect the new price.
> >
> > ...I then will dynamically compare the two dates to determine if there

> has

> > been a price reduction.
> >
> > What would be the best way to go about comparing the original insertion

> date

> > and a later modification date for the two price fields: original and
> > reduced.
> >
> > It appears to me that I cannot use Date () as this would auto. insert a

> date

> > into the modified price date field when the data capturer firsts imserts

> the

> > ORIGINAL PRICE.
> >
> > I could allow the data capturer to select the two dates but this allows

> for

> > input error or incorrect date selection.
> >
> > I appreciate your replies - thanks In advance
> >
> > - Jason
> >
> >

>
>