Recent content by mmiram

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...