B
Brian
I have created a link using ODBC to a read-only table and I want to produce a
table from it.
I have a few requirements that need to be met.
1. Reduce the ODBC Table to only records Equal/Greater to 01/01/07
2. Collect similar Check Numbers from a Check Field and add them to ONE new
record in the new table.
Example:
ODBC Table (Read Only)
CHECK NO. CHECK DATE AMOUNT INVOICE NO
100 01/02/07 5.00 A1
220 04/01/07 10.00 5000
100 01/02/07 300.00 A2
50 11/31/06 500.00 30
Access Table (Results)
CHECK NO. Check DATE INVOICES AMOUNTS
100 01/02/07 A1,A2 5.00,300.00
220 04/01/07 5000 10.00
Note that it did not write Check 50 because it was older than 01/01/07.
I want this to happen from a command button on a form and I realize that it
will ned to include a programming. Can this be done and how?
table from it.
I have a few requirements that need to be met.
1. Reduce the ODBC Table to only records Equal/Greater to 01/01/07
2. Collect similar Check Numbers from a Check Field and add them to ONE new
record in the new table.
Example:
ODBC Table (Read Only)
CHECK NO. CHECK DATE AMOUNT INVOICE NO
100 01/02/07 5.00 A1
220 04/01/07 10.00 5000
100 01/02/07 300.00 A2
50 11/31/06 500.00 30
Access Table (Results)
CHECK NO. Check DATE INVOICES AMOUNTS
100 01/02/07 A1,A2 5.00,300.00
220 04/01/07 5000 10.00
Note that it did not write Check 50 because it was older than 01/01/07.
I want this to happen from a command button on a form and I realize that it
will ned to include a programming. Can this be done and how?