Search results for query: *

Hi all, I m wondering if it is possible to dynamically generate a chart in a report, using some criteria-s selected on a form. Basically i have a couple of tables with the following information. Table1 Employee Department1 Employee Department2 .... ... ... Table2 Employee Skill1 Employee...

I have tried using the Find Duplicate query. I have gotten the results. How do i change the query type in code? I want the report to automatically remove the duplicates. Plus, when i manually changed the type into delete query, and ran it, it deleted everything in my table.

Is there a way to remove duplicate records in access w/o manually pasting with the "structure only" option ? I need to automatically detect and remove duplicate records everytime a report is opened. Thank you all in advance. =]

I need my form to look like the crosstab query. The wizard can't generate something similar to the crosstab table style. The tabular style of the wizard comes close, but it prints out all records in this pattern: field1 field2 field3 data1 data2 weight data1 data3 weight data1...

Thank you for yoru respond, I have tried creating a form based on the cross-table query. It looks great, but i can not input data when the record source is based on the cross-table query. I need to also input data into my table, is there a way around this ?

hi all, I m an Access newbie, this might be a trivial question. I have three tables. 1. Projects table 2. Programs table 3. Programs Vs. Project table - multiple projects can be associated to programs by a percentage. Format of this is: Programs | Project | Weight(in percent) I need to...