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!

Search results for query: *

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

    Unexpected Error 0 in VBA

    hi All, Can you please help me with this error msg. I get an "Unexpected Error" Message box with a Big Red X followed by the message "0:" I have a form with a "FilterOn" based on a text box's after update event. This in turns calls a function that gives me the error. After that my Filter on...
  2. dip757

    Displaying Data Summary in FORMs

    hi i have a table with rows of data As below (Reaseon Delay can only be A, B, C, or D) Order# CustomerName Price FiscalWeek ReasonDelay 1 John D. 1,000 19 A 1 John D. 500 19 B 1 John D. 1,500 19 C 1...
  3. dip757

    Sum Query "Double Counts" data

    Hi, I have 2 tables. One hold header info .... like nameID (primary key) name, address, country. The second table holds donor info: nameID (primarykey), amt, etc...... I QUERY these 2 tables linking by "Name ID" to get the following data: NameID Name Country Amt When I DO NOT do...
  4. dip757

    Doing an "IF" in query Design

    Hi, Can you please tell me how I can do a IF in a query design view. Basically I have a query as follows: ColA ColB ColC ColD 12 14 11 10 In ColC: If (ColA-ColB>0, ColA-ColB, 0) In ColD: If (ColA-ColB<0, ColB-ColA, 0) Please suggest if there's a simpler alternative...

Part and Inventory Search

Back
Top