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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.