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 strongm 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: *

  • Users: mndiscer
  • Content: Threads
  • Order by date
  1. mndiscer

    Query help with a drop down and a text box for criteria

    Hello, I'm trying to create a query where you can select the comparision and enter in the number to compare. So I have a drop down list with <,>,= and have a text box to capture the numeric value. In the query criteria I've tried Forms!Form.DroplistV & Forms!form.NumV and Forms!Form.DroplistV &...
  2. mndiscer

    Communicator 2007 from VBA - Status help

    Hello, I need help pulling the status of a single contact from Communicator. I have the send code figured out. Just can't seem to compile the right verbiage for the status. Want I want is an if statment where depending on the status of the contact it will either send an IM or email. I can figure...
  3. mndiscer

    Access Ranking - Problem with Ties

    Hello, I have the following table ID Store# Genre WOS 1 1000 Action 2 2 1001 Action 4 3 1002 Action 4 4 1003 Action 1 5 1000 RPG 3 6 1001 RPG 1 I would like to group the Genre and rank based off WOS, I have it ranking nicely but my problem is ties. For...
  4. mndiscer

    Update Query Loop Question

    Hi all, Here is my problem, I have the following tables 1. TblStore [Store], [Rank] 2. TblItem [UPC], [Rank], [Store](This is null) TblStore Example [Store] [Rank] 1000 A 1001 B 1002 A 1003 B 1004 B TblItem Example [UPC] [Rank] [Store] 123...
  5. mndiscer

    Grouped running sum

    Hello I have an issue where I think the solution is simple. I have a table with two columns Type=Text Ert=Number I want to create a query that has a 3rd column that does a rolling sum. Example Black 10 10 Black 5 15 Green 2 2 Green 1 3 I've tried the fncRunSum...

Part and Inventory Search

Back
Top