Skip to main content
Question

Hi! Can you help me? How Can I count the Text Data form another table????

  • April 5, 2017
  • 0 replies
  • 98 views
I need to have monthly plan..

I have Yearly plan and in yearly plan I have 

YEARLPLAN

Company ABC - AA, BB and CC Group
Company CDE - CC,DD and EE Groups
Company EFG - EE,FF,GG Groups
Date of Visits-- April, may, June etc 2017 (this may vary)


All I need to do is make monthly plan

For Example
April 2007
Company only - "NUMBER OF GROUPS"

How can I do it?

Thanks for your help
      This topic has been closed for replies.

      Hi Catherine,

      Are you trying to create a report?

      Thanks,
      Gaurav
      • CatheeCathee
      • Author
      • Registered
      • April 5, 2017
      No I am trying to make a monthly plan from yearly plan
      If you are using a summary report then, you can group your rows by year.
      • CatheeCathee
      • Author
      • Registered
      • April 5, 2017
      thanks. but how can I make it that the company only will show.. not the groups
      • CatheeCathee
      • Author
      • Registered
      • April 5, 2017
      HI!



      How can I also write multiple dates.. for example for this company i WILL BE VISITING IT FOR 4 TIMES A YEAR
      • CatheeCathee
      • Author
      • Registered
      • April 5, 2017
      in one company i might have 1-24 visit every year..

      for example form ABC Company... Ill visit them January, April, July and also October.. how can I input multiple dates so it can be summarized by monthly quarterly or yearly
      • MCFNeil
      • Registered
      • April 6, 2017
      My 2 cents for this would be to make the "visits" a child table.  Then just have a "date" field, and you can have multiples, then build many different types of reports based on the date and grouped how you'd like.

      for example.. I have to visit 1 company with many groups...

      Group A- January , May, August and December

      Group B, Feb, april, July, Nov..


      and then many companies in a year.. around 100 companies

      Hi Mr. Guarav
      I sent you an email, are you available?
      I'm fine mr. Guarav. How about you?
      Terms & ConditionsAccessibility statement