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

    Extract letters only from Text Field

    Hi All I have Postcode as a text field and need only the first part of the postcode excluding the number (to later help link in with another table), but its a bit tricky as the first letters of a postcode can range from 1-2 characters: eg: Present: Desired Result: W1V 9DE W BS8 1EY BS...
  2. rickyshah

    Running total in MS Access Query

    Hi, I have 2 fields and I just want to add a field in the design query (cumulative sales) to sum the current and previous records of field "Sales": e.g. Merchant Sales Cumulative Sales 234 100 100 687 50 150 156 200 350 Any help...
  3. rickyshah

    If/Else statement

    Hi All I need help in writing an If or Else statement for the following data. Have 2 variables (Store Number and Type): Example of layout: Store Number Type 123456789 R 123456789 S 987654321 S What I want the statement to be able to do is if the storenumber has...

Part and Inventory Search

Back
Top