Recent content by Mahendra

Dear All, Am trying to create a graph in excel with my values. The categorization of y-axis values are done according to my views and am unable to categorize the x-axis values. I need the x-axis categorization as 0,10,20,30,40,50,60. I tried by viewing many articles and videos but am not...

Reposting my db

Sorry, It's a typo error in a rush to solve this issue as soon as possible :banghead:..... It's an access table :p

How to overcome this issue? We have a datasheet in access with same kind of stuff.. When front end user modifies the end date then the access sutomaticall calculates the remaining columns like quarter, year and month. It won't be saved back in the table..... Alass...... what's the best...

could you let me know how the values from the form can be stored to the main table. The Month, quarter and year values are in the form but not in the main table.

If I use this am facing the issues of updating times. The form needs to be refreshed before seeing the changes. Could you check my demo database attached in my previous post #13.

Thanks for the link CJ_London, I don't know that cross posting is a kind of bad thing in forums. Thanks for notifying me in cross postings and making me aware of these rules and regulations of the forums. I assure you that there will be no such incidents in the future too. Hope you...

The issue with the using of iiF enddate in month is the updation time. It's not updating until the form has been refreshed. (I agree with your previous posts that the data should be first saved in the main table and then it will refresh in form)

I have replied to your posts in #post11 Sorry for combining all in a single post

Attached the sample copy...... Kindly have a look into it.

Thanks for your support CJ_London and vbaInet.. Detailed Explanation I created a table with ID, Start Date, End Date, MonthName, Year and Quarter (Have a look into Table.JPG for main table) and then I created a form with ID, Start Date, End Date, MonthName, Year and Quarter. I linked the...

Thanks for the query vbaInet.. I tried it but it didn't worked.. Still am able to see #type! CJ_London, previously I used the queries of =Year([EndDate]) =Format([EndDate];"q"". Quartal""") It used to update before it has been updated in the main table. Any suggestions from...

Thanks CJ_London, It worked to some extent after making the control source to enddate and formatted as mmmm as stated. When I click on the monthname then the data in the respective column is changing to same as enddate and not showing the month name if the data is selected. Previously when I...

The MonthName, Quarters and Year are automatically calculated based on the End Date.. Kindly have a look into the attached screen shot. You will have an idea for the issue. Thanks

Hello, I have created a demo form where user enters the start date and the end date. The access should automatically display the month name in month column based on the date in end date column. For the control source in month column I have used =MonthName(Month([EndDate])) It...