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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by amacfarl

  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

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

    THANKS!!!!
  7. 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...
  8. 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...
See more

Part and Inventory Search

Back
Top