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 SkipVought 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. novicius

    Easy Table Population Question

    That is *exactly* what I wanted and it worked like a charm! Thank you and case closed! - novicius -
  2. novicius

    Easy Table Population Question

    Hello! My mind is a complete blank on this one and I *know* the answer is easy: In Access XP, I have a 50,000+ record Customer table with all the standard contact fields except "State". How would I craft an Action Query (no code please) to populate the value 'WI' for each record after adding...
  3. novicius

    Group by partial data

    Thanks for the help, Synapse & Witchita! ;) - novicius -
  4. novicius

    Counting Unique Values

    Hi all, I've just run through a few searches and haven't really seen a thread pertaining to my question. I'm working on a client's simple single-file (no other relationships established, grr) FileMaker Pro 7 database and I can't seem to figure out a way to count the unique, repeating values...
  5. novicius

    Group by partial data

    Hi all, Say, I've done a few searches here at T-T.com and haven't found what I'm looking for. Real simple problem, maybe I'm just looking too hard: I have a field of data that is organized into a 1234-5678 format. I would like to group only by the '1234' prefix and ignore the suffixes. How...
  6. novicius

    Security Wizard... now i'm locked out!

    Hello! I'm currently in the same boat here -- trying to define two groups of users, one who can administrate and one who can merely browse. When I try to create either group, I end up getting locked out of the Admin group. Currently, I have just one question: how do I change users in Access...
  7. novicius

    Crystal Reports: Setting color in concantenated formula

    Ah, excellent idea Brian, thanks for the response! But still, how does one use the crBlue color tags in formulas...? - novicius -
  8. novicius

    Crystal Reports: Setting color in concantenated formula

    Hi all, Say, a question regarding using color in Crystal Reports. I've looked up the color tags or attributes for changing color (crBlue, for example) -- only I can't figure out how to implement it. Any ideas? Here's a concantenated sample formula: {Customer.CustomerName} & " (" &...

Part and Inventory Search

Back
Top