Search results for query: *

The update query worked in my test database once the criterian was added to the DLookup function. I appreciate your assistance. You saved me countless hours.

In the qMB_JeffCo_OccTax_Overpayment query, the pr_check_to (social security number) is the unique record. I cannot find an example of how to assign this as a criterian in the DLookup() though. Thanks.

I am still trying to connect to a test database. In the meantime, I have written a select query to test the code you provided earlier. Following is the SQL view of the select query: SELECT employee_incomes.pr_inc_this_onetime, DLookUp("LT2OneTime","qMB_JeffCo_OccTax_Overpayment") AS Expr1...

If I understand your reply, you are saying I need an update query with the code you specified in your thread to perform the change?

I have listed the table structure correctly. There are actually five primary keys and I cannot answer your question as to why that is. I cannot (will not) change the table structure as this is our payroll system. My vendor could do this task for me but then I would learn nothing. Any other...

Using Access 2000, I am trying to update a field of an existing table with the results of a query. The results of the query include a primary key field, the current values in the table, and the desired values for the table. The update query does not seem to fit since the desired values are not...

Using Access 2000, I am trying to update a field of an existing table with the results of a query. The results of the query include a primary key field, the current values in the table, and the desired values for the table. The update query does not seem to fit since the desired values are not...

Defining the columns worked once I got to the right place. The report runs fine now. Thank you for your help.

I opened the crosstab query in design view. The pr_check-categ has been designated as my column heading in the crosstab query. When I click properties for this column, the third row down is "Column Headings". I tried entering my possible column headings in the properties. I am not sure how...

Sorry, you are over my head. If I understand you, I tried to add columns to my crosstab query, then in the column properties in the description and column headings, I entered specific values for the various "+" and "-" incomes and deductions from the table. The error message when I re-run the...

Help me understand the significance of specifying the column headings. The CHECK DISTRIBUTION TABLE has 15 or so incomes ("+") and 30 or so deductions ("-"). Employees can have any combination of the various incomes and deductions. For example: Incomes include SAL, HRS, OT, etc. which can...

Below is the SQL view of the crosstab query: TRANSFORM Sum(employee_checks_dist.pr_check_amt) AS SumOfpr_check_amt SELECT employee_checks.pr_check_to, Sum(employee_checks_dist.pr_check_amt) AS [Total Of pr_check_amt] FROM (employee_checks_dist INNER JOIN employee_checks ON...

Below is the SQL view of the crosstab query. TRANSFORM Sum(employee_checks_dist.pr_check_amt) AS SumOfpr_check_amt SELECT employee_checks.pr_check_to, Sum(employee_checks_dist.pr_check_amt) AS [Total Of pr_check_amt] FROM (employee_checks_dist INNER JOIN employee_checks ON...

I have created a crosstab query from a payroll file which has approximately 50 columns and around 300 rows of data. Some of the columns are calculated controls summing other columns. The query takes about 30 to 45 seconds to run. I am attempting to write a report. The report takes about 30...