G Guest Jun 14, 2005 #1 1 How to set up a primary key in Exel? 2 How to provide a validation of the field to allow only "M"?
V Van T. Dinh Jun 14, 2005 #2 Sorry, wrong newsgroup. This newsgroup is for Microsoft Access, database application. Suggest you re-post to one of the relevant Excel newsgroups. HTH Van T. Dinh MVP (Access)
Sorry, wrong newsgroup. This newsgroup is for Microsoft Access, database application. Suggest you re-post to one of the relevant Excel newsgroups. HTH Van T. Dinh MVP (Access)
J John Vinson Jun 14, 2005 #3 1 How to set up a primary key in Exel? Click to expand... You cannot; Excel is a very good spreadsheet, but it is not a relational database. 2 How to provide a validation of the field to allow only "M"? Click to expand... What would be the point of a field for which every record is identically equal to the letter M????? What are you trying to accomplish? John W. Vinson[MVP]
1 How to set up a primary key in Exel? Click to expand... You cannot; Excel is a very good spreadsheet, but it is not a relational database. 2 How to provide a validation of the field to allow only "M"? Click to expand... What would be the point of a field for which every record is identically equal to the letter M????? What are you trying to accomplish? John W. Vinson[MVP]
