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 bkrike 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: novicius
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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