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 derfloh 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. BoomerBroomer

    Using INSTR function to find text stored in a table

    Sorry I am so slow but it is year end and it is rather time-consuming. I've skinnied down my data base but it has all the essentials. Hope this link below will work. Thanks Boomerhttp://rapidshare.com/files/278305837/Bank_Sorting.mdb
  2. BoomerBroomer

    Using INSTR function to find text stored in a table

    I currently download a HSBC bank statement that contains a field called Bank Reference. Within this field, there are certain unique expressions that I wish to find and assign a code to for my monthly bank reconciliation. For example, AMERICAN EXPRESS is within the field and I would like to...
  3. BoomerBroomer

    Report using a crosstab query

    I set up a planned sales table and an actual sales table with exactly the same stucture with the aim of doing a crosstab query to make my reporting easier. However, I identified the planned sales with a "P" in a type row and actual sales with an "a" in the type row (I used a common "sales" row...
  4. BoomerBroomer

    Fill in field info from previous record

    I have downloaded a report from Simply Accounting into Excel and subsequently into MS Access. The table in Access is as follows (formatted exactly as the report prints in Simply Acctg & I can't get a different format in the source report) (each row is a record): ID PROJECT...

Part and Inventory Search

Back
Top