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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sharonchapman7

    have three tables I need three totals from these tables

    Yes
  2. sharonchapman7

    have three tables I need three totals from these tables

    thank you. Here is the code that works: SELECT [JPAS TASKS].[TASK NO], Sum([PRIOR ACTUALS (PID) QRY].[PRIOR ACTUALS]) AS [SumOfPRIOR ACTUALS], Sum([PRIOR ACTUALS (PID) QRY].[PRIOR ACTUALS]) AS TOTPrior, Sum([PRIOR HOLDBACKS (PID) QRY].[PRIOR HOLDBACKS]) AS [SumOfPRIOR HOLDBACKS], Sum([PRIOR...
  3. sharonchapman7

    have three tables I need three totals from these tables

    Thanks so much. the code below did the trick. Thanks for your help. I do have one problem though. When I try to sum up the total column, it won't sum it up. any suggestions? SELECT A.[Tak NO] , Nz(Sum(B.PriorActuals,0)) AS totPrior , Nz(Sum(C.HoldbackActuals,0)) AS totHoldback ...
  4. sharonchapman7

    have three tables I need three totals from these tables

    I tried the code below. The PriorActuals, totPrior, HoldbackActuals and totHoldback are correct. however, the total column will calculate if there is a number in totHoldback but if there is 0 in totHoldback it won't add the totPrior to the total column. SELECT A.[Tak NO] ...
  5. sharonchapman7

    have three tables I need three totals from these tables

    Here is what my data looks like: three tables: A, B, C Table A has the field Task NO Table B has the fields Task No, PriorActuals Table C has the fields Task No, HoldbackActuals Table A Table B Table C Task NO Task No PriorActuals Task No...
  6. sharonchapman7

    have three tables I need three totals from these tables

    Hi, I am using MS Access 2010 on Windows System 7. I have three tables: A, B, C Table A has the field Task NO Table B has the fields Task No, PriorActuals Table C has the fields Task No, HoldbackActuals I need to create a query that tasks the Task No from Table A and matches it to Table B and...
  7. sharonchapman7

    html page calls default.aspx.vb and gets Ispostback false

    Thank you. I rebuilt the whole thing and now it works.
  8. sharonchapman7

    html page calls default.aspx.vb and gets Ispostback false

    Hi, I have an asp html page that allows the user to input data into a web page. When they click the submit button it calls a default.aspx.vb. The ISPostback is always false so it skips my sql add parameters. Here is the code: <pre lang="xml">&lt;%@ Page Language=&quot;VB&quot...
  9. sharonchapman7

    html page calls default.aspx.vb and gets Ispostback false

    Hi, I have an asp html page that allows the user to input data into a web page. When they click the submit button it calls a default.aspx.vb. The ISPostback is always false so it skips my sql add parameters. Here is the code: <pre lang="xml">&lt;%@ Page Language=&quot;VB&quot...
  10. sharonchapman7

    can't get jquery maskedinput to work

    I see what you mean. I have two laptops but only one of them is connected to the Internet. The laptop I'm working on isn't connected to the Internet. I will take it home tonight and connect it to the Internet. Then I can send you the code. I work for the government, what can I say. Sharon
  11. sharonchapman7

    can't get jquery maskedinput to work

    jpadie, I'm sorry, that was a typo. I am using version 1.8.2. Sharon
  12. sharonchapman7

    can't get jquery maskedinput to work

    the user inputs data and it is written to SQL Server. Attached is my asp code. http://www.mediafire.com/view/?gshn9kd2d5hp8y9
  13. sharonchapman7

    can't get jquery maskedinput to work

    feherke, Thank you for any help you can give me on this. Here is my code: <%@ Page Language="VB" AutoEventWireup="false" CodeFile="default.aspx.vb" Inherits="_default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">...
  14. sharonchapman7

    can't get jquery maskedinput to work

    jpadie, According to the jquery.com website, 1.8.2 is the latest version. Should I be downloading it from some where else? Sharon
  15. sharonchapman7

    can't get jquery maskedinput to work

    Hi, I have the following code in my html page. It works if I test it with alert but when I try to run as is I get the error: Microsoft jScript runtime error: Object doesn't support property or method 'mask' <script src="Scripts/jquery-1.2.8.js" type="text/javascript"></script> <script...
  16. sharonchapman7

    hi, I'm using Visual Basic as my l

    thank you. I will check out the JQuery library. Thanks for getting back to me. Sharon
  17. sharonchapman7

    hi, I'm using Visual Basic as my l

    hi, I'm using Visual Basic as my language with server side scripting. I have two fields, a date and phone field that I would like to put masks on? Can you tell me how I can do this or if it is possible? I'm using asp server side scripting. Can this still be done? I have attached my code as...
  18. sharonchapman7

    two fields on webpage, want same info displayed in second field

    Thanks, someone gave me this code and it works. <script language="javascript"> 02 var copy_field = function(id1,id2) 03 { 04 document.getElementById(id2).value = 05 document.getElementById(id1).value; 06 }; 07 if( !window.onload ) 08 { 09...
  19. sharonchapman7

    hi, I'm using Visual Basic as my l

    Thank you Sharon
  20. sharonchapman7

    two fields on webpage, want same info displayed in second field

    What about in asp.net?

Part and Inventory Search

Back
Top