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!

  • Congratulations SkipVought 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. amacfarl

    Complex Query Question with Joins

    Folks, Have two tables: TblHier Hierarchy Table Fields Level0, Level1, Level2, Level3, Level4 (all int) TblProduct Product Listings Fields ProductNumber, Level0, Level1, Level2, Level3, Level4 (all int) I am using the following query to count how many products have the correct hierarchy...
  2. amacfarl

    Task Manager - No Menu Bar

    Folks, I was looking for at a troubling program in Task Manager, when all of a sudden it changed look. It is now no longer showing the menu bar. Have a look at http://www.geocities.com/amacfarl/taskmanager.jpg I think I was dragging and dropping at the time. On the other users on my pc it is...
  3. amacfarl

    SQL Server Hosting

    Hi Folks, I am looking for a hosting package, and I was wondering if anyone can suggest one. I have a 4GB SQL Server Database, which is queried using JSP. Performance is key as I am using full text indexing. Any suggestions? Regards Angus
  4. amacfarl

    Automatic HTML

    Hi Folks, I have the following HTML form: <FORM action=http://..../......dll method=post> <INPUT type=checkbox CHECKED value=ON name=sendcopy> <INPUT maxLength=100 size=60 value=&quot;Question&quot; name=subject> <TEXTAREA name=message rows=7 wrap=VIRTUAL cols=58></TEXTAREA> <INPUT...
  5. amacfarl

    UPDATE QUERY

    THANKS!!
  6. amacfarl

    UPDATE QUERY

    Hi, Once again SQL is driving me up the wall ;-) Scenario: Two tables, T_Sellers - Listing all the seller information T_Sales - Listing all sales by product. I am wanting to update a field in T_Sellers which is the total number of sales for that seller (NumOfSales). I have written...
  7. amacfarl

    Query Issue... Oh Boy! MS Access....give me a break!

    Folks, I have the following table in MS Access: TABLE: ProductsForSales Seller Category IsSold QUESTION 1: I know that you cannot use COUNT(DISTINCT xx) in MS Access. However how can I run a query returning the number of Categories the Seller is currently Selling in...

Part and Inventory Search

Back
Top