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 Chriss Miller 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 bsound83

  1. bsound83

    Creating a balance

    SELECT tblSessionSales.ClientID, [FirstName] & "" & [LastName] AS ClientName, Sum([PricePerSession]*[QtyOfPackages]) AS Balance FROM (tblSessionSales INNER JOIN tblTanPackage ON tblSessionSales.TanPackID = tblTanPackage.TanPackID) INNER JOIN tblClient ON tblSessionSales.ClientID =...
  2. bsound83

    Creating a balance

    Hello repliers.....I'm finally back. I'm basically trying to normalize the data information from the POS software...it's horrible that the data does not have a primary key to differentiate each row. I've tried my best to normalized the data and attached is what I got so far...I've tried finding...
  3. bsound83

    Creating a balance

    The big one that I'm more concerned with is the tblSalesHistory...that provides all of the transaction, but your right...even that table does not have a primary key to differentiate each item line. The only table that I imported from the POS was the tblSalesHistory and tblClient...everything...
  4. bsound83

    Creating a balance

    here is the converted filehttp://www.box.net/shared/4yrxtz88wc
  5. bsound83

    Creating a balance

    I'm not sure if the first link is the right one. Try this one. http://www.box.net/shared/u0fvatgg0o
  6. bsound83

    Creating a balance

    I attached my table to view. http://www.box.net/signup/collablink/d_17274277/3f2375a035baf
  7. bsound83

    Creating a balance

    Your right fneily...at this particular moment...I'm trying to tweak access to suit the data from my POS. It's not that big of a deal...at the same time I get to learn how to utilize Access which will go a long way. The table you offered are really all I need...I inherited the POS software...it's...
  8. bsound83

    Creating a balance

    Actually...the tables are a little more in depth than the examples I provided. I am actually pulling data from a POS software that I am able to extract the data as a dBF file, which create all my tables...and I have been creating additional tables to sort out what I wanted...for instance, I had...
  9. bsound83

    Creating a balance

    I am a beginner with ms access 2003 and have recently been playing with access because it can hold more records than excel. I have the following in a table: DATE CUST# TRANSTYPE DESCRIP QTY COST 1/1/08 12345 B PRE-PAID SALE 10 $50.00 1/2/08 12345 C...
See more

Part and Inventory Search

Back
Top