Access DB combining records query or process

I have an Access 2003 database with 2 tables.

Summary is a very large table with 1 summary record for all the transactions per account and sub-account per day. So if 1 account has 3 sub-accounts on April 4, 2009, it will have 3 records that sum up all the transactions for each account/sub-account/date combination. It currently has approximately 500,000 records.

I receive a transactions table on a periodic basis. It is also a very large table, with up to 500,000 records. There is unpredictable overlap between the transactions table I receive and the current summary table. If there are any records in the transactions table for which there is already an account & date record in the summary table, then I don't want to import those (note that this ignores the sub-accounts at this point). I then want to summarize all the other transaction records by account/sub-account/date and add them to the summary table.

I'm looking for a sql query or another simple process that I can use to do this process as quickly as possible. I would prefer that this process not change the data in the transactions table or create temporary tables, but am willing to do either if that is the only solution. My initial attempt was to delete all the records from the transactions table using a subquery but that takes far too long.

I'm going to put $30 in escrow for this project. I'm looking for a query or process that will run quickly, along with a clear explanation of how the query works.

Taidot: tietojenkäsittely

Näytä lisää: design query large table access, combining data access query, access combining records, use escrow to import, transaction escrow, n query, how escrow account works, access to escrow account, combine records access 2003, sub account query, combining records access, access 500000 records, access combining records based date criteria, access 2007, db transaction, clear my account, how escrow works, escrow transactions, db escrow, summary table, summarize, SQL Query, SQL Access, simple query, query table

Tietoa työnantajasta:
( 4 arvostelua ) Boston, United States

Projektin tunnus: #419473

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, Please check my PM !!! Regards, Techno SGIT

$30 USD 0 päivässä
(18 arvostelua)

Hi there, No problem then im an excel and access vba expert with over 11 years experience. Please can you provide more details in PMB then. THanks Nash

$30 USD 0 päivässä
(7 arvostelua)

Hello Please see your PMB for details. Thanks John

$30 USD 0 päivässä
(4 arvostelua)

So long as you don't mind me taking it out of access and using mysql or another db platform, I think I can help you out, and provide an ANSI-SQL compliant, commented, readable query to work from. I have three solid ye Lisää

$30 USD 0 päivässä
(0 arvostelua)

Hi there. actually wat u need is not possible by a single or multiple lines of query in MSACCESs. either u need one tool which does these queries in batch. or u will need some other pure sql compliant database. lik Lisää

$30 USD 1 päivässä
(0 arvostelua)

this is no problem then im an excel and access expert with over 20 years experience. Dezi

$30 USD 0 päivässä
(0 arvostelua)

I know how to make this without changing the data in the transactions table or create temporary tables.

$30 USD 2 päivässä
(0 arvostelua)

I am a VB and Access Programmer and proficient in all types of database design, query and programming. please give me further details

$30 USD 7 päivässä
(0 arvostelua)