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 Rhinorhino 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: supind
  • Content: Threads
  • Order by date
  1. supind

    search records in a recordset

    I need to search for duplicate fields in a recordset then set another field in the duplicate set to null. I cannot seem to make anything I try work. Any help would be welcomed! Here is what I need: Table: TBL_ProdScrap Fiedls: CastingPN CastGood FinMachGood What I need is to...
  2. supind

    find record if then

    I am having a difficult time getting started with this report I am trying to create. I am fairly new at programming and any help anyone can give me would be greatly appreciated. I want to match records from TBL-CastProduction to TBL-ProdScrap by Casting PN.I think I need to use an if...then but...
  3. supind

    Updating a specific group of records

    I could really use some help on this one. I am trying to create a recordset based on recordsets from other databases. Here is an example of my data: QRY-CastCross: Date CastingPN TotalScrap TotalShots QRY-FluorCross: Date CastingPN RejQty TotalQty QRY-FinPackCross Date MachiningPN CompanyPN...
  4. supind

    append query is changing the case of letters

    I have an odd thing happening. Hopefully someone can shed some light for me as to why. I have a field (PartNumber) that is a combination of numbers and uppper case letters. In the crosstab query that is used for they append query, the PartNumber field appears correctly. Yet, when I run the...
  5. supind

    combining unrelated fields

    Hi. I hope someone can help me. I am trying to create a report that joins multiple unrelated fields into one report. I need to have these fields grouped under one main category. TBL-Casting: fields Casting PN and Casting Description TBL-CastProduction: fields CastingPN, Date, and Shots...

Part and Inventory Search

Back
Top