iIF function (1 Viewer)

S

saravanan900

Registered User.

Local time

Today, 07:16

Joined

Jun 5, 2018

Messages

16

• Jul 3, 2018

• #21

saravanan900 said:

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

Click to expand...

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

 

S

saravanan900

Registered User.

Local time

Today, 07:16

Joined

Jun 5, 2018

Messages

16

• Jul 5, 2018

• #22

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

• TECHNICAL SUBMISSION RREGISTER.accdb

  1.3 MB · Views: 31

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 12:16

Joined

May 7, 2009

Messages

19,233

• Jul 5, 2018

• #23

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

• TECHNICAL SUBMISSION RREGISTER(1).zip

  127.4 KB · Views: 30

S

saravanan900

Registered User.

Local time

Today, 07:16

Joined

Jun 5, 2018

Messages

16

• Jul 5, 2018

• #24

arnelgp said:

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.

Click to expand...

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

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 12:16

Joined

May 7, 2009

Messages

19,233

• Jul 5, 2018

• #25

You are welcome.

 

S

saravanan900

Registered User.

Local time

Today, 07:16

Joined

Jun 5, 2018

Messages

16

• Jul 25, 2018

• #26

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

• DRAWING REGISTER.accdb

  1.8 MB · Views: 40
• Drawings Status.xlsx

  10.5 KB · Views: 54

S

saravanan900

Registered User.

Local time

Today, 07:16

Joined

Jun 5, 2018

Messages

16

• Aug 2, 2018

• #27

Good Morning Sir,
How can i increase the character from 255 to 1000 or more

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 12:16

Joined

May 7, 2009

Messages

19,233

• Aug 2, 2018

• #28

you edit the table and change field fieldtype to long text.