Tiffany,
Could work to use the VIN as the primary key still, and for those vehicles missing the VIN use something like "NoVINxxxxxxx" with a sequential number inserted to track those records.
Tim
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Tiffany-
>
> Ugh. Of course, the VIN should be the Primary Key of the table, so if you're missing the VIN, it may not be possible to record all the data.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
> Sent: Wednesday, September 28, 2011 3:20 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Change color of record based on event???
>
> John,
> It is spotty and i was going to hand enter all the records. There are only 128 records in the sold table, they do have a unit number, not all have a vin or license number, all have a sold date. Some say you they were sold to some not, but they are not all broke down with information in each column, they just started typing the info in a cell. Soo merge these two will not work, the data has to all be picked through and had entered.
>
Tidak ada komentar:
Posting Komentar