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 rickyshah

  1. rickyshah

    Extract letters only from Text Field

    Hi All The query has got a little trickier, what do I need to do if I need the following output from the postcode field. Basically need to add back the number but drop off any ending with letters eg: Present: Desired Result: W1V 9DE W1 SW1E 1EY SW1 B2 1YR B2 CV6...
  2. rickyshah

    Extract letters only from Text Field

    This seems to have worked, thanks alot!
  3. 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...
  4. rickyshah

    Running total in MS Access Query

    Sorry the previous example wasnt so clear, but actually the records are ordered in descending order on sales. ( I do not want to sort records by merchant as using the sales field for ranking) Thanks. eg. Merchant Sales Cumulative Sales 234 200 350 156 100...
  5. 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...
  6. rickyshah

    If/Else statement

    Hi Skip, Don't worry think I've got it, used the MIN option when grouping the data. Thanks. Ricky
  7. rickyshah

    If/Else statement

    Hi Skip, Thanks for the tip, but is there a way to insert this in An access query in design view as I am not too familiar with SQL. Thanks.
  8. 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...
See more

Part and Inventory Search

Back
Top