Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query result different in Access 97 and Access 2000
The following query matches records where two absolute numbers (i.e. 10.123 and 20.234) are between a certain round number (i.e. 15). To make this match possible I use Int() to convert the abs.numbers in the DB to an Integer without fraction. To prevent formatting errors the data-type of the... -
Get Primary Key Column?
How can I get the Primary Key column(s) from an MSaccess database-table? I want to make a simple dynamic table-editor to use instead of CFGRID. I found column_list very handy, unfortunately I found no such variable for determining whether or not a field is primary,unique etc. I tried looking...
