Table behavior (or design) problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a table with seven fields, including an autonumber field as the
primary key, a date field, and a time field. The date field is
formatted as short date. The date field is the field that is giving
me problems.

My problem, I want to count the number of records that have the same
date. I designed a select query to count the number of records with
each date. The problem is that each record, even though they have the
same date, appears as a discreet record because the date field
includes not only the date that is entered but also inserts the time
that the record is entered. When you look at the data in table view,
the only data in the date field is the date that was entered.
However, when the mouse pointer is hovered in the date field and
clicked, the date that is entered along with the time of entry
displays.

How can I get this table to only store the date that is entered?

.

Relevant Pages

  • Re: Data Primary key vs. Artificial (Autonumber) primary key
    ... sorry to distract you with minor issues, like the SSN and name fields. ... primary key based on data fields versus using a primary key based on an ... the autonumber field would be used for defining relations between tables. ... Are there any negative aspects associated with the BlueClaw approach? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Re-Seed in SQL Server
    ... Add a new field to the table that holds the Primary Key. ... or something like that and make it an Autonumber field and a Primary Key. ... If the table is already on the SQL Server you could try the below. ... that your Autonumber field in the Access Database has gotten corrupted. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Recap On Design Assistance
    ... Q.Is the SKU number in fact unique to a store? ... Q.MarketNumber CANNOT be the Primary Key; doing so would limit you to ... a combination key of market and SKU. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Export to Excel and Update status in Table and Unrelated question
    ... the Contact table is the Parent table and the Phone table is the Child ... every table should have a Primary Key. ... Since it is not a law that Primary Keys be an autonumber field ...
    (microsoft.public.access.forms)
  • Re: Export to Excel and Update status in Table and Unrelated question
    ... the Contact table is the Parent table and the Phone table is the Child ... every table should have a Primary Key. ... Since it is not a law that Primary Keys be an autonumber field ...
    (microsoft.public.access.forms)