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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Numeric Datatypes and ComboBoxes
I have an Access 2002 project that is linked to an SQL Server 2000 database that has Numeric primary keys with a precision of 38 and a scale of 2. This allows me to create ID numbers like 1.01, 2.01 and so forth. I am trying to create a Combo Box that has a rowsource that points to one of the...- jakem
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
Trouble querying float column
I am trying to query a table that contains a Primary Key which is set as a float data type and a nvarchar field that stores names. For instance I have a record where the ID is 75.01 and the name is Bob Tucker. When I try to search for this record using the followwng query no records are...- jakem
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Access 'First Function' in SQL Server
Does anyone know of a nice alternative to MS Access' 'First Function' in SQL Server. For instance, if I run the following query in Access it will return the first row of data in the Title table: Select First(Title) As FTitle, ISBN, Call_Number From Title However, if I try to run this in SQL...- jakem
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
