adding SQL Query to make Custom POS button

Shoby,

SELECT [Transaction].Time, [Transaction].TransactionNumber, [Transaction].StoreID, IsNull(Store.Name, '''') AS StoreName, [Transaction].ReferenceNumber, Item.ItemLookUpCode, TransactionEntry.Price, TransactionEntry.Quantity, Item.Description FROM TransactionEntry INNER JOIN [Transaction] ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber AND TransactionEntry.StoreID = [Transaction].StoreID INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID LEFT JOIN Item ON TransactionEntry.ItemID = Item.ID LEFT JOIN Store ON TransactionEntry.StoreID = Store.ID WHERE Customer.AccountNumber='0000001'

- Evan Culver New West Technologies

Shoby wrote:

Were you able to create custom button with sql query.

How can i create custom butt> Shoby,