Access 2000 - Senior Design Help

[spacebass5000]

I am trying to embed a graph object in a Data Access Page and have control
objects that will display the desired data by passing variables to the query
that will be used by my graph. I imagine that the graph wont be displayed
until the variables are actually sent. I am working with an Access 2000
Database and my fields are as such.

Some unit number | The date MM/DD/YYYY | Hour of Day

Basically, I have a sensor that when tripped adds an record with its number,
date, and hour it tripped. I want to display the data in numerous formats so
i figured I would do this with DAP's and some sort of control interface that
would allow the user to easily view the data as he/she sees fit. This is a
small part of a Senior Design project so I will spare you the rest.

Is this possible? If so, can you send me in the right direction as to what I
should do?

Also, I as it stands now when I use the function Date() I get it in this
formart: MM/DD/YY

How would I go about making it look like MM/DD/YYYY?

Thanks in advance!

 

[spacebass5000]

bump

 

[tekola]

YOu can specify the format of a date as "mm/dd/yyyy" in the fields properties