Recent content by nupur

Hi Thank you so much for your explanation. :) This worked but based on your assumed scenario, I also want to add different dates for columns X and Y based on the condition. For eg: If my condition is 1 then dateadd("d", 5, start date) as X but if my condition is 2 then dateadd ("d", 10, start...

Thanks for your response. I am sorry but I didn't understand the query. What I want to do is if scenario is 1 or 2 then x (which is the calculated column) = "NA" else if scenario is 3 or 4, then x = x. Could you please explain your query?

Thank you :) Can I make the end users add comments/reasons in the comments section in report I have previously created? Does this requires VBA programming?

I have a report in access with different columns. There are few "comments" sections as well. I want the end users to add comments or reasons in those columns. How can I do that in a report. I have searched all the properties sheet but could not find anything. Do I need to write some VBA code for...

Thank you!! You are awesome. I just have one more question. Now that I have modified the query, whenever I open my form as well as report in the design view, it seems all blank. I have check the visibility in the properties section and everything looks good to me. I can only view the fields for...

Hi!! I have created a report in access which will populate based on the selection criteria in a form. The report contains certain due dates for different stages of a process. I want to add blank column in my report along with each due date field so that if anybody has passed the due date...

Hi! I have a date column in my database (suppose start date) which I have to use for calculating other dates (suppose the calculated dates columns are x, y and z). To do this I used the DateAdd function and the results were good. But now based on different conditions (suppose there are 4...

Thanks :).. Just wanted to ask if with this code my displayed results would change based on my selection criteria. for eg: if I choose Jan 2010 to get a list of products for this month (which would be in a separate form or report). For looking at the results of Feb 2010, do I need to create...

Thank you so much for you reply :)

I need help in creating a form that can query a database and generate reports in access. For eg: if I want to know what type of products were sold in year 2010, I will select the type of product from a "product combo box" and then will select the 2010 month from "month combo box". After clicking...