Search results for query: *

I have two tables: tblDeposits (App, Bank, Account) and tblMatrix (App, Bank, Account, Year, Amount) The composite primary key in tblDeposits is App + Bank + Account. The composite primary key in tblMatrix is App + Bank + Account + Year. I have a form where user chooses Year from a combo box...

I would like to use one database form to run an update in 4 external access databases. Master.mdb has 1 form called frmAutomation which has one combo box called cboPeriod. I would like to add a command button to this form adding vba code to the "on click" event. When clicked, the code will...

To append new records from tblOne to tblTwo, I use an action append query to add records where the id field in tblOne does not exist in tblTwo. I am trying to do this using vba rather than an action query. Below is my code. The code compiles and executes but 0 records are appended (no error...

While in query design view, I am trying to rename a column/field name to Adj-01 (see formula below; This works fine, however, when I save and exit the query, and then go back in, access renames the column/field name to Adj-1. The "0" gets ommitted. Since I am using the precise field name in a...

Does anyone know how to create a select query to display a dynamic # of columns from a underlying query. I have a table called <tblMatrix> with 13 fields/columns: Account 01 02 03 04 05 06 07 08 09 10 11 12 where columns 01 thru 12 represent months with financial data or null values. I know...

I am trying to mimic the vlookup functionality of excel in access where there isn't an exact match. tblStore has 4 fields (sample data) Store Year Week Manager A 2007 01 Jack A 2007 05 Cindy B 2007 01 Tom C 2007 26 Bill The way to read this data is Jack is the manager...

I have two tables: tblBalance has 2 fields (Account & Balance) tblCrosstab has 13 fields (Account, Jan, Feb, ..., Dec) tbl balance always has the current months balance. At the end of each month, I have an update query which says to update [Mth] in the tblCrosstab using the latest balance...

I mirrored my code of a similar post which did not seem to work for me. thread705-1375620. I have a table <tblPercent> which hold department, and product, and percent data across region. Here is some sample data. Department Product North South East West 1 A 25 25 25 25...

I have table (tblSales) with 3 fields: product, department and percent. The percent field is "double" number format. Sample Data Product Dept Percent A 1 .308 B 1 .506 C 1 .186 Each Department should add up to 1 (or 100%). I must load this data into an oracle...