AnsweredAssumed Answered

List of Users

Question asked by thong127 on Jul 21, 2015
Latest reply on Jul 21, 2015 by SteveMartino

Title

List of Users

Post

Hi All,

I have two tables Users & Daily Reports, In my Users table I have the following  fields:

                                                                                                                                                                                                                                                                                                   
Field NamesTypesOptions
UserIDTextAuto-enter Serial
AccountNameCalculationGet ( AccountName )
CreationAccountTextCreation Account Name

In my Daily Reports Table I have the following fields:

                                                                                                                                                                                                                                                                                                                                                                                                                                               
Field NamesTypesOptions
ID_DailyReportsTextAuto-enter Serial
AccountNameCalculationGet ( AccountName )
CreationAccountTextCreation Account Name
ProjectCodeTextIndexed
ActivitiesTextIndexed

 The two tables are connected by UserID & ID_DailyReports

I am making a summary that will show the User Names on the top (Horizontal) and on my Vertical will be the Project Codes.

Please find attached excel image of what Im trying to accomplish.

Thank you so much in advance to any help that you can extend.

 

Lola

Untitled.png

Outcomes