Okay, these are the steps:
1. When the Main report opens, it bring a form that has 2 fields for Dates, then There is a option group below the fields. (this is were I click to select what type of filtering is needed.)
2. Next, I click on the preview button which then opens my report.
I have attached a sample of the database.
Thanks again.
Mario...
Mr Hero
Last Activity: Nov 9 '10, 06:33 PM
Joined: Oct 5 '10
Location:
-
Gnawoncents,
I tried both of your suggestions, the first one gave me a error message saying it was too complex. The other one nothing showed...Leave a comment:
-
IIF statement problems.
I need assitance with my IIF statement.
IIf([Reports]![RptMaster]![ChkBxs]="1",True,II f([Reports]![RptMaster]![ChkBxs]="2",False,I If([Reports]![RptMaster]![ChkBxs]="3",,)))
I have a column in my table that stores values from a check box in my form.
I have a form that has a option group in it, and it has 3 buttons to select from. Depending on the value, you can get 1, 2 or... -
Thank you.Leave a comment:
-
Thanks Nico! I appreciate you taking the time to explain some these issues.
I have a question, can I use type casting in a event to store without getting a data type mismatch?Leave a comment:
-
I have made some progress, I ended up making some changes due to a recent step back... I do like the problem solve phase. However, It is the implementation part that always gets me confused. Is there way, I could convert some of this process into an event? or it is a best practice to use a qry in conjuction with VBA?Leave a comment:
-
A million thanks for your help. I appreciate your patience with me, as I am still learning and trying to wrap my head around Access.Leave a comment:
-
Okay, it seems to me that I am lost... I wasn't sure how to use the DMAX() function in my qry. I have attached a sample where I am testing everything that I am suggested. I really would appreciate some assistance. Thanks!!...Leave a comment:
-
I have hit a few stops. Nevertheless, I think I know where I went wrong.
I have a little experience with Access. However, I would say my experience level is intermediate.
Thanks for taking the time to assist me. =D I will keep you posted on as I attempt to make this work. Thanks.Leave a comment:
-
Okay, I am not having much luck. Do know where I can look at an example?Leave a comment:
-
Hmm... Thanks for the guidance, I will continue and see how this turns out.Leave a comment:
-
Well, that is interesting, what if I added to a form on the onOpen event to run a query and use the DateDif to calculate the amount of days from the begining of the yr.Leave a comment:
-
That makes sense. =D
Okay, I have one more question. Every two weeks I need this qtyIn to increase by 6. Will I need to write some Code to make this happen? or is it possible to have a qry to this process?Leave a comment:
-
Nico,
I was able to find the Normalization article. The theories of practice makes sense. I am not sure how this will solve my question.
I have created the input table, in which it has all the records for me to pull into a report. The reason I was wonder if the Balance table can be updated, is because I have more then one type of Item. i.e. Chairs has 100, windows has 100, etc. a total of 10 items. How would I update...Leave a comment:
-
Hi Nic;o),
I am not sure what you mean by "The proper balance can be deducted when needed." Can you explain a little.
Thanks!Leave a comment:
-
Table updates as form inputs into another table.
I have 2 tables, one table is for the form to input records; and the other table is for keeping balances. How can I get my Balances table to update as new entries (+ or -) is entered in the input table? Any assistance is greatly appreciated!!!! =D
No activity results to display
Leave a comment: