Search results

The datatype is TEXT. Rpt master contains the field which displays 1 or 2. Inside Rpt Master there is a subreport which has a field and in this field I have my IIF statement.

Sry for the confusion, I named a fieled "ChkBoxs". I see how this can be confusing. I could have named it something else for less confusion.

I have this formula in one of my field's control scource. =IIf([Reports]![RptMaster]![ChkBxs]="1",[dateFiledGriev],[dateDiaryAll]) But this isn't working... I am recieveing #Error. Any assistance is greatly appreciated!! Thanks in advance :D.

Thanks Bob! :D

Bob, I made a few changes to the operation of the DB. I came accross a few different issues. One, I have 4 sub reports that are inside the Main report (RptMaster). Two, I tried to modify your suggestion to fit the changes, and I failed :confused:. Would you mind helping me with this change...

Bob, Your solution is absolutely perfect! A million thanks.:D Mario

Simon, I have attached a sample of what I have done so far. Would you mind looking at the attachment and assist me with this? Thanks a bunch mate. Mario

I need assitance with my IIF statement. IIf([Reports]![RptMaster]![ChkBxs]="1",True,IIf([Reports]![RptMaster]![ChkBxs]="2",False,IIf([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...

Would this process have to do with Normalization?

Dave, Thanks for the analogy. I am following a little better now. In some ways, you have hit the nail on the head in what I was trying to understand. With this being said, I believe that I need to break down my confusion into manageable parts and try not to do all of it at once. On a previous...

I am lost. I have tried to understand and apply your suggestions. I am not sure how I have managed to digress from my original path but I have. In fact, I have deviated significantly. I see what your pointing towards, somewhat, but adding 20 to -6 to get my answer doesn't make sense. Since...

Now, I have a main entry table, a table with the start balance, and a table for a qry to append data into. I have used a single expression to calculate the data. I need some help with this part. I can get the balance to subtract and update into a table. But it is taking the original balance and...

I will try to change the way the this process is going. Just from your suggestions I see where I may have made this process very difficult. Althought I may understand I am not sure that restructuring will create a solution for updating the balance. But I will try and see where I end up. Thanks.

Oh... Okay, then how can I ultilize access in a better? I have managed to get the information to store correctly. But, updating the other table as I make new entries is my problem. I am not sure what to do.. Do I need to make a qry, or do I write some code to select, calculate, then append?

I have attached a image that explains a little of the layout. I am having some difficulty explaining the issue.

Dave, Well my tblMain is used for the the Input form. In a sense tblmain is the foundation, I don't want any manipulation or changes to be done to this table. The tblEmpsBal is also the same way, because it contains the beginning balance from the first day of the year. This tbl is not allowed...

I have 3 tables (tblMain,tblEmpsBal,tblEmpsCurBal). Table tblMain is the main data table. Table tblEmpsBal contains individuals names/balance. Table tblEmpsCurBal contains the individuals updated balances. Currently I am updating tblEmpsCurBal by manually udding the entries in tblMain...

Mr Smin, I tried your suggestion. Works, but there is more to it then just that part. I am sorry if this sounds a little confusing. the New table will keep track of the subtraction. So when the qry processes the information, there is record kept for every single subtraction. I hope this make...

I have 2 tables that contains 2 fields each (ID, and StartNumber) and (ID, SubtractNum). I have tried creating a qry to clone the StartNumber field then the subtratnum is subtracted from the StartNumber an entry is made that links with the correct ID; next, the qry updates the calculated balance...

use the post reply (not the quick reply), then scroll down and look for a button that says manage attachments.