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!

Recent content by supind

  1. supind

    search records in a recordset

    I got it to work. Thank you so much!! Now I can stop banging my head on the wall. At least until the next problem arises. ONce again, thank you!
  2. supind

    search records in a recordset

    Thank you for your help PHV. I really appreciate it. I had no problem with the first query, but the second one is giving me problems. I keep getting the error "Join expression not supported." At one point I tried something different and I got the error that I couldnt run the query because it was...
  3. 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...
  4. supind

    find record if then

    Thank you. I will play with this and see if I can make it work. I have been having a hard time getting the fields from the different tables to blend togther without multiplying. As for the names of the tables, they are mostly what the original programmer named them. It is way too complicated to...
  5. 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...
  6. 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...
  7. supind

    append query is changing the case of letters

    The part numbers take the following format: 43-551SESB, 43-6005A, 43-7044 or some combination thereof with the letters always following the numbers. Only some of the part numbers are affected. For example, I will append 10 records with the 43-6005A part number but a few of them will be with an...
  8. supind

    append query is changing the case of letters

    No that isnt the reason but I appreciate your reply.
  9. 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...
  10. supind

    combining unrelated fields

    Thank you so much. That seems to have worked. I appreciate your help.
  11. supind

    combining unrelated fields

    I will do my best to show how I need the data to be output. Sample Data: TBL-Casting: Casting PN Casting Description 40123 Jeep Liberty 43783 Freshening 43925 Duraclad TBL-CastProduction: Casting PN Date Shots 40123 2/14/05...
  12. 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...
See more

Part and Inventory Search

Back
Top