how do i change the date format in access to be short date?

I am new at access and I have to change the date in my paper to be "short
date" and I have no clue what I am doing...this is the last part of my paper
to turn in for college and I am doing it online so there is not much help I
can get other than online.. I already have the table done..but I can retype
it if necessary but I just need to change the date format for that table to
be "short date". Thanks

The format of a date field is controlled in the reports, forms, or queries.
The entry is stored in the table as an integer that represents the date.

If you wish to change the way the date displays on a report or form, use the
control's "Format" property and set it to "Short Date". You could also add
an unbound control and put something like the following in it...

=Format([SomeFieldName],"Short Date")

--
Rick B



"Shana" wrote in message
...
I am new at access and I have to change the date in my paper to be "short
date" and I have no clue what I am doing...this is the last part of my
paper
to turn in for college and I am doing it online so there is not much help
I
can get other than online.. I already have the table done..but I can
retype
it if necessary but I just need to change the date format for that table
to
be "short date". Thanks

Go into the table in design view. Select the row with the date. At the
bottom of the page you will see "format" change the drop down to short date.
Save and view your table.

"Shana" wrote:

I am new at access and I have to change the date in my paper to be "short
date" and I have no clue what I am doing...this is the last part of my paper
to turn in for college and I am doing it online so there is not much help I
can get other than online.. I already have the table done..but I can retype
it if necessary but I just need to change the date format for that table to
be "short date". Thanks

Thanks so much...I got it done now...Thanks

"Bryan" wrote:

Go into the table in design view. Select the row with the date. At the
bottom of the page you will see "format" change the drop down to short date.
Save and view your table.

"Shana" wrote:

I am new at access and I have to change the date in my paper to be "short
date" and I have no clue what I am doing...this is the last part of my paper
to turn in for college and I am doing it online so there is not much help I
can get other than online.. I already have the table done..but I can retype
it if necessary but I just need to change the date format for that table to
be "short date". Thanks

Hello sir
how is posible to change sorting date not based on binery numbers? as you
know, in binery, month will be sort 1, 10, 11, 12, 2, ... 9, how can i change
it? it must be 1,2,3,4,5,6,7,8,9,10,11,12

thanks
yousefi

"Rick B" wrote:

The format of a date field is controlled in the reports, forms, or queries.
The entry is stored in the table as an integer that represents the date.

If you wish to change the way the date displays on a report or form, use the
control's "Format" property and set it to "Short Date". You could also add
an unbound control and put something like the following in it...

=Format([SomeFieldName],"Short Date")

--
Rick B



"Shana" wrote in message
...
I am new at access and I have to change the date in my paper to be "short
date" and I have no clue what I am doing...this is the last part of my
paper
to turn in for college and I am doing it online so there is not much help
I
can get other than online.. I already have the table done..but I can
retype
it if necessary but I just need to change the date format for that table
to
be "short date". Thanks

It has nothing to do with binary numbers. Format changes whatever is being
formatted into a string, and sorting as a string, 10 is less than 2.

If you need ShortDate for display purposes, you can either sort on an
unformatted version of your date field (you don't have to make it visible in
the query's recordset), or you can format it as yyyy-mm-dd.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"yousefi" wrote in message
...
Hello sir
how is posible to change sorting date not based on binery numbers? as you
know, in binery, month will be sort 1, 10, 11, 12, 2, ... 9, how can i
change
it? it must be 1,2,3,4,5,6,7,8,9,10,11,12

thanks
yousefi

"Rick B" wrote:

The format of a date field is controlled in the reports, forms, or
queries.
The entry is stored in the table as an integer that represents the date.

If you wish to change the way the date displays on a report or form, use
the
control's "Format" property and set it to "Short Date". You could also
add
an unbound control and put something like the following in it...

=Format([SomeFieldName],"Short Date")

--
Rick B



"Shana" wrote in message
...
I am new at access and I have to change the date in my paper to be
"short
date" and I have no clue what I am doing...this is the last part of my
paper
to turn in for college and I am doing it online so there is not much
help
I
can get other than online.. I already have the table done..but I can
retype
it if necessary but I just need to change the date format for that
table
to
be "short date". Thanks