Search results

Oops, I guess I created the subform in the Footer section, instead of the DETAIL section of the Main Form. So I tried to copy the Subform from the Footer section to the DETAIL section, but lost references to calculated controls...so if I can't solve I'll start again. If you have any pointers on...

What step did I miss that the Subform is not listed in the Tab Order in the DETAIL section of the Main Form? The subform's Tab Stop (and all associated fields) are set to "Yes" for Tab Stop. How do I move the "frmInvoiceSubform" from the Form Footer Section to the DETAIL section of the Main...

Thank you all for your helpful advice and instruction. I will retain the tips from jdraw for future reference also as I continue to learn. I could not get the right result with Nz, (syntax issues, etc.) so I'll stick with IIf =0 for now. Thanks everyone. :)

I guess the fact that there is a checkbox in the field means there is "something" in the field? I was able to use IIf(IsNull) with the Company field when the field was completely blank because the record was for an individual who did not have a company. So I will stick with the =0 for the...

Thank you for your prompt response. Would there be another way to properly use the IIf(IsNull) statement for this query? Can I change the TYPE of the PickupRequired field (which is a checkbox) to another TYPE other than Yes/No? (The concept I am trying to learn is how to use the IIf(IsNull)...

Why does the first statement yield correct results, but the IIf(IsNull) statement does not? (It places the same value in both columns, subtracting the PickupRequired Fee for both True and False conditions, whether PickupRequired box is checked or unchecked.) This works: NetDonation...

Love the simplicity and it works so well. Thank you so much!:o

I am studying Access 2010 on my own, with a comprehensive text and files, while working on a database at the office. Years ago, I was a member of the "MrExcel" forum, asking questions there. Since I am not a programmer, but just a user aspiring toward proficiency for certification, I prefer...