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!
-
help Selecting distinct records
hello, Here is my query. select 'MNOP' as [Workstream], count([Functional Specs]) as [Total Functional Specifications] , count([Test Case]) as [Total Functional Specifications Covered ] from (Select distinct r.requirement_name as [Functional Specs], tt.[Test Name] as [Test Case] from...- rk33
- Thread
- Replies: 17
- Forum: Microsoft: Access Other topics
-
Issues with Type conversion
Hi, I have a text field in an MS ACCESS table which contains a decimal number. How can the number be converted from decimal to integer. Example String = 10.54 Needs to be converted to 10 and can remain a string... Please help asap Thanks,- rk33
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
