iIF function

Thank you very much for your help.
I need one more coloum for open items (Under Review) and total in that report. One more question about document type that if there is lot of document type i should add manually in Criteria In ("MS","MT","PL","RD").

Good Morning Sir,
If you have time please help me to put total for Status A + B +W + I + Open in the last coloum.
 
Re: Report

Good Morning Sir,
If you have time please help me to put total(Sum) for Status A + B +W + I + Open in the last coloum.I have attached access file.
 

Attachments

i made a new Query (StatusTotalCount) which has same criteria as in
(Status Summary) query. Link it the query (Status Summary).

Added the the New Column (TotalCount) from Status Summary query
to the Report.
 

Attachments

i made a new Query (StatusTotalCount) which has same criteria as in
(Status Summary) query. Link it the query (Status Summary).

Added the the New Column (TotalCount) from Status Summary query
to the Report.

Mr.Arnelgp,
Thank you for your help. Really really thank you. You are genius. I am a just starter.
:):)
 
You are welcome.
 
Report

Dear Sir,

Good morning

I have attached Access file and report sample in Excel. If you could help me to get that report it will be highly appreciated. In the Design register there is Preliminary drawings, Detailed drawings, Concept drawings included.
 

Attachments

Good Morning Sir,
How can i increase the character from 255 to 1000 or more
 
you edit the table and change field fieldtype to long text.
 

Users who are viewing this thread

Back
Top Bottom