Recent content by sundance

Just the query

I still have the duplicates. I need to figure out a way to remove them. My totals need to match the general ledger. Any other ideas? Thanks for your help

I created a query combining Beg Inv table, Purchases table, Sales table, Adjustment tables. All tables are linked with referential integrity. However I'm getting duplicates for purchases, Sales, Adj.. I added columns with auto numbers for each purchases, sales and adj. I just don't know...

Hi, I know enough about Access to be dangerous. I've passed the Microsoft Access Specialist exam, as well as taken beginning courses for Access 2003 and 2007. I'm trying to expand my knowledge by doing some volunteer work with Access to get some real life experiences. Sundance:)