Search results for query: *

I am not if my title makes sense. I have an asp report pulling from access. I need to display the information like this: User Name 1 Item 1 Item 2 Item 3 User Name 2 Item 1 Item 2 User Name 3 Item 1 I am not sure how to structure my page and the query loop to display the info like this...

Hey gurus... I have a secure web page that contains mostly static HTML. However, I have one area that needs to have dynamic data update every 15 seconds. I do not want to have to refresh the whole page every 15 seconds. What is the best way to go about this? Thanks

This is probably simple to solve. I have two tables - sales and checklist. Sales Table ID - AutoNum Date - Date CustName - Text SaleAmount - Currency Checklist Table ID - AutoNum SaleID - Num IntroLetter - Date Review -Date InstallComplete - Date I need to create a page that shows the...

I have a HTML List box (<select multiple>) that is populated from a table. I need the user to select multiple options. Then insert into a second table the selections with the same selection ID. I am assuming I need to loop my insert statement somehow, I'm just not sure how. Can anyone help? Thanks

Greetings, I am not sure I understand how to do a looped insert and could use some help and maybe some code examples so that I can undertand what's happening. I have read some posts regarding this but I don't think I have enough info to know if what I am reading applies. I have two tables in...

Greetings, I'm not sure is this is the right forums or not... I have a live audio stream using WMP and encoder. I would like my page to check for a stream prior to loading the page. If there is no stream then a redirect to an "off-line" page with some static asf file playing. Does anyone have...

SELECT sales.RSMID, rsm.FName, rsm.LName, sales.ID AS SalesID, sales.DateSold, sales.CustName, sales.SysConfig, host.HostName, salestype.SaleType, sales.Amount, (Select Sum(B.Amount) From Sales B Where B.RSMID=Sales.RSMID AND Month(B.DateSold)=1) AS MTD, sales.Margin, rsm.Goal FROM ((rsm INNER...

I have this query ti give me a running sum from my sales table. SELECT A.RSMID, A.Amount, (SELECT Sum(B.Amount) FROM Sales B WHERE B.RSMID=A.RSMID ) As RunningAmount FROM Sales A This gives me: RSMID, Amount, RunningAmount 37 55000 96000 37 41000 96000 38 20000 20000...

Okay.. here's an easy one... Function result(Number) Select Case Number Case 1 to 5 result = "hi" Case 6 to 10 result = "Bye" end Select End Function I get the "expected statement" error. I think this has to do with the "to". How do I do a range in VBscript/ASP? Thanks

What I have: SalesPersonName Month 1 Date Cust Amount YTD Date Cust Amount YTD Month 2 Date Cust Amount YTD Date Cust Amount YTD What I Need: SalesPersonName Month 1 Date Cust Amount YTD Date Cust Amount YTD Month 1 Total: [SUM of Amount for Month] Month 2 Date Cust Amount YTD Date Cust...

I am not sure how to explain this. I would like my web page to display some info like this: Person One Name Item 1 Item 2 Item 3 Person Two Name Item 1 Item 2 Item 3 I have a query that pulls all of the data I need from two tables. I have tried using Do While loops in diferent places to get...

I suck at query writing. Can anyone help me out? Its probably something simple I am leaving out. Thanks CODE: strSQL = "SELECT DatePart("m",[DateSold]) AS AMonth, Sum(Amount) AS MonthTotal FROM sales GROUP BY DatePart("m",[DateSold])ORDER BY DatePart("m",[DateSold])" Error: xpected end of...

Greetings, I am a SQL noob. I am working in Access. I am moving a spreadsheet that housed the sales/commission data to Access. The commission is paid out in a stair-step type of plan; i.e. $1 to $100 = 10% $101 to $500 = 20%. Your sales YTD amount places you in the bracket. The bracket...

I have a table that holds a salesman name, the date the item was sold and the amount an item was sold at. I need to spit out each month a line item report that shows the above information with a year to date column as well. Example: Salesman DateSold Amount YTD Bob 05/20/04 100...

Greetings, My customer has a fax server that connects to teleco or PBX's via a T1 card. The customer wants to run all Outside Trunks through the IPO and then into the fax server. The fax server will connect to a T1 card in the IPO. What needs to be enabled in the IPO to allow the fax server to...

Greetings, I have a customer that is using a third party predictive dialer with IVR options. They want to have Symposium route certain inbound calls to the IVR (for credit card payments) the IVR needs to receive DNIS digits. I know the Avaya Definity can do this. Will the Sympsoium? The digits...

Greetings, I need to connect a predictive dialer behind a Legend with an R3 proccessor. My prefered method of connectivity is with station side T1s (the phone system &quot;sees&quot; the dialer channels as extensions in a hunt group). Will this version of the Legend suppor this? Do I use D100...

Will a Legend T1 card support Loop Start Signaling? Thanks