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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using a Function in SQL statement
I need to be able to run a function as part of my SQL statement. The function is running some calculations that (when completed) will be averaged by using groups. I have no problems running the function separately, however, I need to create reports that are grouped by user locations. with...- kwfrazier
- Thread
- Replies: 6
- Forum: Microsoft: ASP (Active Server Pages)
-
Difficult SQL statement, works in Access, not in ASP
I have a difficult SQL statement that is really giving me a hard time in getting results to display on my ASP page. Here's the background: I have an Access 2000 DB with a main data table called TBL_MasterData for a ticket system. I have a stored query that groups the table's records by...- kwfrazier
- Thread
- Replies: 3
- Forum: Microsoft: ASP (Active Server Pages)
-
Determine which variable has lowest value
Hello all! I need to compare 9 variables from a record and find out which one has the lowest value. Based on that, I can then assign a team to the overall record. I may need to weigh questions in case of a tie in score. I can write If/Then/Else statements to do this, but it seems rather...- kwfrazier
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Conditional Format on result from DB lookup.
I am looking to highlight a row(s) of results from a DB lookup based on a returned field. If the field value for any record is 4, then highlight in yellow. If the field value for any record is 5+, then highlight in red. Basically I want to do conditional formatting on each row based on a...- kwfrazier
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
