Search results

I need to calculate a variance between actual and budget. Some projects have only Budget data but not Actual data. When I calculate the variance, it gives me #error. I used a subreport to get Actuals. The link of this sureport to main report is Project ID. There is always Budget for each...

Hi, RV, Thanks for your reply. I am new to Access, so I am not sure I know how to do what you said. Basically, I want to get group sum in my report using the budget number from a subreport. Many previous posts suggested using HasData method. But so far, it is not working for me. And I...

I am not able to convert my example to 97 Version. Can anyone help me with that? Thanks a lot.

I am trying to use HasData method to get SUM using subreport data. Attached is an example I did. But it still asks me to enter the .hasData parameter. Could anyone tell me what I did wrong? Why it does not work. Rich, if you are there, could you please give me a hand again? Thank you...

Thank you very much, Sam. It works. I will go to get more info. about this.

hello, Not sure if this is right placeto post. In the subreport, I calculated a difference between budget and actual. I want to present this difference in a way that if it is positive, then just show it the way it is, but if it is a negative number, I want to show it in a (). FOr example, if...

I have created a list box that shows all the projects' names. Now, I want to add another column in this list box that allow user to choose YES or No for each individual project. In creating a table, you can set a variable as YES or No type. Can I do something like this in the list box. Thank...

Thanks a lot.

Thank you.

I used a combo box to let user select "Proejct Status" such as active, completed, cancled. I want to set active as a default selection if user does not choose other status. How can I do that? Thank you very much for your help.

I created a form to let user enter project summary. However, the maximum charaters is 255. What can I do to allow more charaters be entered in the form? I already set up "can grow" as yes. Thank you.

Can anyone help me? Please I created three combo boxes in a form. User can choose a category from combo 1 and a list of projects in that category will be shown in combo 2. If user choose a project in combo 2, that project will be shown in combo 3. Currently, the choice from combo 1 is...