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 TouchToneTommy 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. seekinganswers

    Runtime 9 errors after migrating to Exchange 2000

    After migrating to Exchange 2000, Outlook 2000 users with an XP OS are receiving runtime 9 errors. Deleting profile resolves, but there are far too many. Any ideas?
  2. seekinganswers

    Query or Report?

    I need to show who made honor roll. Seems simple right? So where do I put the criteria which is >="B" AND no "F". I've tried queries and report footers without success. Layout as follows: GradesTbl ID Name Course Teacher Grade MP1 Each student has at least four...
  3. seekinganswers

    Track overtime - who's next - based on senority and who worked last

    As Curly said, "I'm trying to think, but nothins happenin!" If I have an Emp table; EmpID Name Title Date of Hire And a OT Tracking table; OTID EmpID Date of OT Hours worked/refused Number of hours worked Can I get a form to open at the next person who should be asked to work based...
  4. seekinganswers

    Help pulling out lowest bid then summing them by a criteria

    I need to find the lowest bid of a line item. Then I need to sum each vendors lowest bid for a report. My Tables: TblBid TblLineItems TblVendor TblBidTrack BidID LineItemID VendorID VendorID BidNo BidID VendName BidID BidDate...
  5. seekinganswers

    Lowest bids summed

    I can't seem to get my head around this one. A public school sends out requests for bids. The vendors fill them in and return them. Upon return from the various vendors each bid is compared line item by line item. If a vendor bids low on line items 1 and 6 that's all the vendor is awarded. My...
  6. seekinganswers

    Access Rpt - Iif statement works but I need both text and currency

    After much trial and error, I managed to get the data I wanted by using the following Iif statement =IIf([TotBidAmts]=0,"No Bid",[TotBidAmts]). But, I need those TotBidAmts not = zero to appear in currency format. Possible?

Part and Inventory Search

Back
Top