Search results for query: *

well, I am not sure that I understand you exactly but our product sizes would vary based on client requirements...for e.g. I could have a client ordering 2.35 x 3.67 which is not a standard size. As such, I cannot have a list of products and the sheets that are optimal for those products. I...

Hi all, Here is what I am trying to do. We are a printing company. We print on different paper sizes. The sizes we print on are: 8.5 x 11 11 x 17 12 x 18 14.33 x 20.5 We offer different products ranging from business cards to posters. What I am trying to do is create a calculator that...

Hey Skip, That worked great, thanks. CBasicAsslembler, the reason I could not do what you suggested is because the percentage varies for different products and different quantities...it is not fixed. Thanks for all your help guys.

No, the reason it cannot be a formula is, I want the amount that is contained in B27, the very first time, the negative amount becomes positive in B50. B50 keeps changing even after it goes positive. I do not want the value in D27 to keep changing everytime B50 changes. The event should be...

Hi all, I am trying to create a sales commission calculator for all the sales people in our office. Just before I get into my exact problem, I will try and explain how the system works. The sales people get a certain base salary. They sell different products all of which have different...

Hi all, We recently moved to a new email server from exchange. As part of the move, we all added the new IMAP account in Outlook 2002 and moved some of our email messages into the new IMAP folders from the exchange folders. I for the most part, exported my messages into a pst file and then...

Hi all, I just posted this question before and realized that I had "datalist" listed as "dataset". I tried deleting that post but could not. It has been that kind of day. Anyway.. I understand that if I use a datalist, it wraps the <table> tag around the code. However, I do not want the...

Hi all, I understand that if I use a dataset, it wraps the <table> tag around the code. However, I do not want the <tr> and the <td> tag that it seems to add as well. Here is what the HTML output looks like if I use a data set <table id="dlMailingList" cellspacing="0" headerte=""...

Hi Golom: Thanks for the code. For the most part it works fine with minor syntax changes. The only change I had to make was to get the right counts. E.g. I had to change the following code Select Q.[LID] As [Agent], Q.[LName] As [AName], Q.[State], Q.[County] , 1 As [DoubleEnd]...

Hi all: I have the following table structure: Address City State Zip Close Date Close Price LID LA First Name LA Last Name SID SA First Name SA Last Name County The above table reflects the transactions conducted by our agents. Every transaction has two sides, the listing side represented by...

It works great :) Thanks a lot.

Hi all: I am new to SQL server and am running into a few issues with my queries. I have the following query: SELECT SubdivisionName, sum(DivCount) FROM (SELECT Subdivisions.SubdivisionName, HouseDetails.HouseCount AS DivCount, Subdivisions.SubdivisionID FROM Subdivisions, HouseDetails WHERE...

Hey Remou: Sorry for the late reply but it works great...thanks a lot.

Hi Remou, Thanks for the reply. However, I still have the issue. I have a customer ID "1005" with transaction volumes as below: County Volume MC $500 DC $300 When I ran your query, "1005" showed up in the top 1000 lists of both...

Hi all: I have one table with the following fields. Customer ID Customer First Name Customer Last Name Customer Transaction Number Customer Transaction Volume County There are customers who do transactions in more than one county. In those cases we have multiple records for that customer. I...

Hey guys, Sorry for the late reply but the code worked perfectly. Thanks a lot. Ram.

Hi all: I am trying to create a dynamic image tag in an HTML file using ASP. I am kind of a beginner and am having issues with the code. Here is the issue The code is as follows: <% If Request.QueryString("CID")="LF" And left(Request.QueryString("TID"),2)="JL" Then...

Hi all: I have two tables: march05 and march06 Both tables have the following fields: ID Name Qty Amount The problem is march05 has some items that march06 does not and vice versa. There are other items that are present in both tables. I want to write a query that will generate the...

I am not an expert here but I had a similar problem with my exchange server (where users were getting the message "Could not open one or more attachments." and the attachments were missing). For almost two weeks, I had this issue. I finally figured out that it had more to do with the...

thats interesting. I will check it out. I just ran the query DISTINCTAGENTS separately and the sumofCLprice column does not have any NULL fields. So my guess is the query DISTINCTAGENTS is not running fast enough to get the results for all rows when the main query is running. Also, I don't...