Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: boone35223
  • Content: Threads
  • Order by date
  1. boone35223

    Updating an Access 200 Table with the Results of a Query

    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...
  2. boone35223

    Transfer the results of an Access query into a field of existing table

    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...
  3. boone35223

    Re: thread703-1592285 / Access 2000 report [user] issue

    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...
  4. boone35223

    Access 2000 reporting [user] issue

    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...

Part and Inventory Search

Back
Top