Search results for query: *

No, there isn't a large div with all 5 groups of checkboxes in it. I thought about using one but I'm not real familiar with using them in Javascript. Would this work: <script language="javascript" type="text/javascript"> <!-- function checkCheckBoxes() { if...

Thanks for your response however I don't want them to be required to check at least one in EACH group, I just need them to check at least one in ANY group. It doesn't look like this code will work for this. Will it?

I tried this but it's not quite working. I actually have 5 checkbox groups. I only put 2 in the original code to simplify my question. I need it to only submit the form if at least one checkbox is checked in ANY group. I want it to return an error message if they don't select ANY checkboxes...

Thanks! That's exactly what I needed was the getElementByID part. Thanks again.

I have 2 sets of checkboxes and I don't want the customer to submit the form unless they have checked at least one checkbox in either set. I am giving each set of checkboxes the same name because of the code used to send the information through an e-mail. This is what I have: <script...

I got it working. I had to make a minor change: SELECT * FROM vHDIncidentLog Inner Join ( SELECT Distinct IncidentID As Incidents FROM HelpDeskIncidentDetails WHERE TimeStamp BETWEEN '1/2/2003' AND '10/2/2004' ) As A On...

Thank you. It amazes me that someone can just look at the code and come up with an answer so quickly. Unfortunately it returns this error message: Invalid column name 'IncidentId'. I'm trying to figure out which one is the problem. In the meantime you might be able to find it quicker than...

I'm not sure how to do this but I have a database that has Incidents that have an IncidentID. There are usually multiple records for an IncidentID - they are seperate events for each Incident. I was searching for the records by the timestamp date but I wouldn't get all of the events for a...

This was working until I added a link to a header. Now it defaults to January instead of December. When I remove the link to the header it works. I don't understand how that would affect it. I know that some javascripts interfere with letting others work however I can't see the code for the...

Thanks for all of your help. I had tried the cInt but it didn't work but I did it wrong. That is now working. Thanks for rewriting the ElseIf statement for me. I sometimes forget that it's easier to do that. Thanks again!!!!

I have a month and year that I am passing from another page and I want to compare it to the current date and even when they are the same it's not recognizing them as being the same. Here's the code: sMonth = Request.Form("Month") sYear = Request.Form("Year") CurrentMonth = Month(Date)...

It works great!!!!!!! Thanks!!!!!!

Well now that it's January I'm able to see if this works and it doesn't work quite right. It does for the year (it shows 2006 & 2007 in the dropdown list). However it's supposed to default to December 2006. In December it worked to default to November 2006 I guess the new year throws it off...

Thanks ESquared. Your suggestion worked. I had tried something similar to that with the float but the syntax must have been wrong because it didn't work. I had already tried converting it to a decimal but I got an error message that said: Arithmetic overflow error converting numeric to data...

I am trying to get an average of some fields and instead of 48.85 it's returning 48. How can I fix this?

I researched more on LEFT OUTER JOIN's and one of the websites showed the syntax a little bit different. Instead of doing the WHERE statement it was done in the LEFT OUTER JOIN part. This is what I did and it worked: SELECT tUnits.UnitNum, tUnits.UnitNameAbbrv, tDBHReports.QM231 FROM...

Yes, that is correct. It would only return the rows where there was a corresponding UnitNum in the second table. I took your advice and did the following: SELECT tUnits.UnitNum, tUnits.UnitNameAbbrv, tDBHReports.QM231 FROM dbo.tUnits LEFT OUTER JOIN dbo.tDBHReports ON dbo.tUnits.UnitNum =...

Unfortunately it's not working because there isn't a NULL in the database. There isn't one at all. However I would think that with the LEFT OUTER JOIN it would at least return a record if there is one in tUnits. Is the following correct to get each one in tUnits? FROM dbo.tUnits LEFT OUTER...

The Matrix is creating the columns for the records that exist in the second table but not for the ones that don't because there isn't a record so there aren't even any NULL's. If there were records with NULL's it would work. As far as doing a SELECT on both tDBHReports and tUnits UnitNum...

I changed it from: FROM tDBHReports INNER JOIN tUnits ON tDBHReports.UnitNum = tUnits.UnitNum to: FROM dbo.tUnits LEFT OUTER JOIN dbo.tDBHReports ON dbo.tUnits.UnitNum = dbo.tDBHReports.UnitNum Because it's the tUnits table that has the full list that I want included whether or not there is...