By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Report Enggwise

P: 8
Hello,
now i want to disp report Enggwise.

Platform Ms-Access
Field name - Engg_nm
Table -register
Report Name -Enggwise


I want to create report which is display information of Engg wise. Ex. If I Choose Engg name - JVG then display How many complaint he is complaited in this monh. disply complaint_no, Date, Client_nm, Problem,Remark, Complate_dt in Report.

Thanks.
Dec 27 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
Just create first a report to show all complaints per "Name"
When activating the report you can add a stCriteria to filter for the specific name.

Nic;o)
Dec 30 '07 #2

P: 8
JVG
thanks but i dont understood. can u tell me deep.
Dec 31 '07 #3

nico5038
Expert 2.5K+
P: 3,072
about:
"How many complaint he is complaited in this monh. disply complaint_no, Date, Client_nm, Problem,Remark, Complate_dt in Report"

Would require a report with the fields from the table like:
complaint_no, Date, Client_nm, Problem,Remark, Complate_dt
When placing a button on a form you can add the specific Client_nm to filter the report with.

To count per Client use a groupby query like:
Expand|Select|Wrap|Line Numbers
  1. select Client_nm Count(*) As CountOfComplaints from tblYours Group by Client_nm;
  2.  
And define the report based on this query.

Nic;o)
Dec 31 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.