Search results for query: *

I'm sorry guys... i am close ... but still need some help on the codes. Zathras... Your code ran and created the new sheets but it did not populate the sheets with the data. Ramzi... I changed the 'sheet1' from your code to the name of my sheet with the data and got a vb error on line 2...

Yes... they are in seperate columns. state, city, count thanks!

Hey Ramzisaab... I've tried that code ... and i see where it is going .. but i have a problem.. for each state is listed multiple times... eg.. California Los Angeles 12 California San Francisco 35 California San Diego 50 Florida Orlando 30 Florida Miami 20 so... i would need to grab the...

Hi, I have a list of states, cities within the state, and counts of patrons in each city in one long list. I'd like to know if theres a way to create a new worksheet for each state? thanks

Do you have privileges to connect to that db via ODBC?

Well... i figured i can create a query to pull in the ProductID and Quantitiy for all and compute a subtotal for each table, then create another query to do the final computing based on the three subtotals i just got. This will probably work but i was looking for a cleaner way to do it in forms/vb.

Hi... I have 5 tables. tblProducts tblIn tblOut tblOrders tblOrdersDetails I'm creating a form that will allow entries into tblIn. In this form i would like a textbox to display current inventory via calculation. Logic of calculation as follows.. CurrentInventory = sum(tblIn.quantity) -...

Try this: -- select CUSTNUMB ,CUSTNAME ,CUSTADDR ,OVERALL_VALUE from CUSTOMER ,(select CUSTNUM ,SUM(QUANTITY * PRICE) OVERALL_VALUE from ORDERS, PRODUCT where ORDERS.PRODNUM = PRODUCT.PRODNUM and SYSDATE - ORDDATE <= 30 having SUM(QUANTITY * PRICE) >= 500 group by CUSTNUM...

Hello, I have a table of two columns one is ID and the second is Year_Of_Service. IDs are duplicated in this table where there are more than one year of service. Does anyone know of a logic in sql that can find all the IDs that have at least 5 consecutive years of Service. Any suggestions will...