Chopstick,
I had actually tried this but ran into a logistical problem. Here's a sample of data:
State City Address TimeStamp
FL Orlando 123Here 8/1/2003
FL Orlando 123Here 8/11/2003
AL Mobile 234There 8/5/2003
AL Mobile 567Not 8/7/2003
I...
Workday() is a function in the ASP code, it is also available in the DB itself which is in Access 2000.
Thanks,
Kenneth Frazier, MCSE, CCA
Network Engineer
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...
HA HA HA!!!
Don't I feel like a moron !!!
That's what I get for copy/paste instead of hand coding the statement. Works great now!!!! Thanks for the extra eye!!!!!
Thanks,
Kenneth Frazier, MCSE, CCA
Network Engineer
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...
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...
All help is greatly appreciated - send it on! You can use the column headers and I'll modify as needed. Thanks again!
Thanks,
Kenneth Frazier, MCSE, CCA
Network Engineer
This looks to be exactly what I'm looking for, however, when you use FrontPage to connect to a DB, the back-end code is a bit confusing. On top of that, it doesn't use response.write to return results.
The interesting piece would be to modify your code to 'work' with the FP junk... I want to...
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...
I am doing something similar - I want to search using the Like statement; however, if I try to use the & * portion, the FP Results show no records found. Here's my working FP code:
SELECT * FROM Results
WHERE ((Results.PSN) Like '::PSN::')
Now, if I add the & *, here's what I have:
SELECT *...
I'm doing the same thing, however, I need to generate the filenames dynamically. For example, the first part of the filename will be built from an existing variable value.
Dim RPTDate as String
RPTDate = some calculation
SendKeys(RPTDate & "Remaining FileName.foo")
Any Ideas?
Thanks...
When I use this with a table, it works great; however, when I specify a Query, the function fails and wants to debug the line with the query name on it. My query has one field that uses a form control as the criteria.
Basically, Iwant to run a query against an entered ID number (not unique)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.