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

    Record Selection for Cash Register Journal . . .

    Hello all, I am using Crystal 7.0 to report from a cash register's electronic journal stored in Btrieve. I can't figure out how to tell the Record Selection Builder to select ALL lines from the transaction that contains a product from department 'meat' on '2009/01/02'. Table: Trans Date...
  2. BEVer69

    UPDATE based on joined tables

    I am relatively new to SQL and would appreciate your insight on formulated the following statement. I have two tables representing the header (ek2122) and detail items (ek2124) of a purchase order. I would like to update a value in the details based on a join between the two tables. Here is...
  3. BEVer69

    How to join table in a VIEW without using UNION

    Hello, I am new to SQL and need a hand creating a view in Pervasive PSQL v8. The first table called ITEM2 contains a text field which needs to be split apart into 10 separate fields and joined to a table called PROMOCODE. The following select statement is not pretty but works so far for the...

Part and Inventory Search

Back
Top