User Profile

Collapse

Profile Sidebar

Collapse
Jeya Rexon
Jeya Rexon
Last Activity: Feb 12 '15, 05:39 AM
Joined: Nov 15 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jeya Rexon
    replied to Current & lastweek completed %
    in Access
    Dear twinnyfo

    I Need your help. So nothing I have to hide.

    1) Query -1 (Status as on date.19-11-14)
    2) Query -1 (Status as on date.26-11-14)

    The above are same query. For your explanation I have shown you as two screenshots in different dates.

    I used the code for the query-1 is :

    SELECT [Tbl WWTP Procedures].ProcedureNumbe r, [Tbl WWTP Procedures].[Draft Complete],...
    See more | Go to post

      Leave a comment:

    • Jeya Rexon
      started a topic Current & lastweek completed %
      in Access

      Current & lastweek completed %

      Hello twinnyfo,

      Thanks for your continous reply.

      If I am confusing you, sorry. Forget about the previous postings and attachements. I am telling straight way with this new posting.

      Herewith I have attached 3 attachements as: Query -1 (Status as on date.19-11-14), Query -1 (Status as on date.26-11-14) and Query -3 (Current & lastweek completed %).

      1) Query -1 (Status as on date.19-11-14)...
      See more | Go to post
      • Jeya Rexon
        replied to How to get the formula for weekly change %
        in Access
        Hi twinnyfo

        I want to add some new attachement. I couldnt attach with this reply. So I have posted as new posting on today (26.11.14). Please see my new posting with attachements.

        Regards
        Rexon...
        See more | Go to post

          Leave a comment:

        • Jeya Rexon
          replied to How to lock the tables, query & Forms
          in Access
          Thanks for your suggesion.

          I will try to hide those tables and lock with snapshot option method.

          Thanks again for your reply.

          Rexon...
          See more | Go to post

            Leave a comment:

          • Jeya Rexon
            replied to How to get the formula for weekly change %
            in Access
            Thanks for your reply twinnyfo,

            My boss needs in Access format only.

            Can you try this task for me, Please?

            Thank you

            Rexon...
            See more | Go to post

              Leave a comment:

            • Jeya Rexon
              started a topic How to lock the tables, query & Forms
              in Access

              How to lock the tables, query & Forms

              Hi,

              Can you help me how to lock the tables, query, and forms in access 2010?

              Just only the users can see the table, query and forms?

              Please suggest.

              Rexon
              See more | Go to post
              • Jeya Rexon
                started a topic How to get the formula for weekly change %
                in Access

                How to get the formula for weekly change %

                Hi twinnyfo,

                I am giving my thanks and appreciate your quick reply.
                I forgot my password. so I writing this from another ID. Ok

                As per your suggestion, if I make queries as Week-1, and Week-2, I need to put the data separately in every week on week tables. Then only I will get the weekly change out put.

                But My boss needs, when we update the records (in date/time type) every week in the query (as...
                See more | Go to post
                No activity results to display
                Show More
                Working...