Search results for query: *

Hi, That didn't work. It gives me an error of: Undefined function 'Nz' in expression

Ken, I changed the Select Statement to: SELECT Nz(Format(Sum(Dashboard.Recycled_Usage),'#,###'),0) AS SumofRecy, Nz(Format(Sum(Dashboard.Usage),'#,###'),0) AS SumofUsg, Nz(Format(Sum(Dashboard.Bit_Amt),'#,###'),0) AS SumofBit From Dashboard ... Now, when the value is NOT Null, I get the...

No, I haven't heard of this function, but I'll definitely look into it. Thanks for your help.

How can I display something other than this Invalid Use of Null error? I know there is no data in the database for what I've searched on, but I don't want the user to see this error. I'd rather see something like "No Results Found for your Search". Here is some of my code: These...

I have a website for my office that I need help with... Currently, it pulls data based on Month, but now that 2004 is coming, I'm adding a variable to include the year as well. So, now I've got the code pulling up the year and displaying 2003, 2004, 2005 (pulls this from the database). The user...

Thanks rac2! That worked perfectly!

Does anyone know if I can take the following 5 queries and make them into one? They are all querying the same table for similar criteria. QUERY #1: TOTAL FOR FRAGMENT 1: SELECT Clng(Sum(Dashboard.Recycled_Usage)) AS SumOfRecycle, Clng(Sum(Dashboard.Usage)) AS SumOfUsage...

I have a website form where a user will enter various data that will update an Access database through the mssql code in my page. I am receiving an error : "Syntax error in INSERT INTO statement", which is related to the 2 Date/Time fields I have in the form. My guess is that the...

While your answers may work, part of the problem is that I am not using MSAccess other than to store the data. I am querying the data via the web using msSql in .jsp pages. So, I am taking these suggestions and trying to manipulate them so they will work with my code. Unfortunately, I don't...

Thanks for your response! I'm going to try it out now. Could you tell me what the backslash is for in CStr(A\60)?

Not that it matters much...but there was a typo in my explanation above...EndTime is 22:07:23 Thanks

I am calculating how long a job runs using jsp & sql to query a MSAccess DB . I have a StartTime (6:14:33) and EndTime (20:07:23) and I have calculated the time TotalTime (=15:52:50). Code: Format((StartTime - EndTime), 'HH:MM:SS') AS TotalTime My question is: Is there a way to 1.) Round to...

Thanks RiverGuy! That's exactly right. I'm only using Access to hold the information. I'm not using the forms, reports, buttons, etc. HTML and Java are used to create the web page. I had to tweek my code a little bit, but your suggestion worked! Thanks so much :)

pwise, Thanks for your reply, but I'm using sql, java, and jsp to display these results to a web page. I'm just using Access to store the data. It looks like the code you gave would work for a module in Access. Maybe I posted this to the wrong forum... Thanks anyways.

I'm not sure if I'm posting this in the right forum, but I think this could be done using sql..just not sure how. Is it possible to create a report (displayed on a website) based on criteria selected from a form? (3 or 4 drop down boxes) i.e. User selects Month: April, Team: 1 and 2. Can I...

I'm not sure if I'm posting this in the right forum, but I think this could be done using sql..just not sure how. Is it possible to create a report (displayed on a website) based on criteria selected from a form? (3 or 4 drop down boxes) i.e. User selects Month: April, Team: 1 and 2. Can I...

Hi all, Is there a way to export data using html table information which is displayed on the screen to MSExcel? Currently what the users have to do is drag the mouse over the html table and then click ctrl c to copy the information which is displayed as raw html table and then open up excel...

onpnt, Thanks so much for your response. I started from the bottom, and worked my way up. Every validation works until I get to the textboxes... if (txtCheckPrintable(AddProjForm.initnum, true, "Initiative Number Missing. Error: ") && txtCheckPrintable(AddProjForm.projname...

Hi, I am trying to validate a form when the user hits the submit button. Currently, when a field is left blank, an error message pops up to instruct the user to enter something in the blank field, but when you click Ok on the error message, it processes the submit (which processes a query). I...

Thanks for checking my code. When I remove the quotes around the if statement, I get the following error: ';' expected. " INNER JOIN BCV_Status ON Projects.project_id = BCV_Status.Project_Id)" ^ I didn't think I should put a ; before the if. Am I missing something else? Thanks again.