Search results for query: *

Hi Tony, Your code did the trick! And it's much simpler than all the stuff I tried that didn't work. Many thanks, slocat

Most of our reports are based on a fiscal year and we have a number of forms which require the user to select the fiscal year from a dropdown list. The contents of the list come from the following code in the "Row Source" field of the Properties dialog box: SELECT FiscalYears.FiscYear...

Perfect! The whole form works like a charm. Thanks Terry and Mike for all your help! Sally

I'm still having the same problem. I have tried many versions of the following: IIf(nz([Forms]![frmCustom]![HZip].[Value],"")="" Or nz([Forms]![frmCustom]![HZip].[Value],Is Null) Is Null,[H_Zip],[Forms]![frmCustom]![HZip].[Value]) and they all have the same result: any...

Mike, I thought it made sense, but I'm not getting it to work. Here's my code: IIf(nz([Forms]![frmCustom]![HZip].[Value],"")="" Or (nz([Forms]![frmCustom]![HZip].[Value],"")=Null),[H_Zip],[Forms]![frmCustom]![HZip].[Value]) I'm getting the same results as before...

Mike, I am also trying to create a similar form where the user can choose which criteria to base the report on. Your code: IIF(nz(Forms![MyForm]!MyBox.Value,"")="",[MyField],Forms![MyForm]!MyBox.Value) has been very useful for most of my form fields, text or otherwise...

Thank you, Maq! That was just what I needed and much simpler than the code I was fumbling around with. Slocat

I have created several reports where it would be useful to know how many records are included in the report before printing. For example, it would be nice to know how many labels will be printed before loading the printer. I am trying to create a popup form that displays the record count when...

GOT IT! Actually the Group By generates an error message, but I don't need it anyway. The following produces just what I want: SELECT Activity, ActivityDate FROM MembActivity WHERE ActivityDate=(SELECT Max(ActivityDate) FROM MembActivity WHERE MEMB_NUMB = "28686") THANK YOU! I...

Thanks for sticking with me! I tried the code above and it gave me a syntax error (missing operator) message. The following gets no error message: SELECT Activity, MAX(ActivityDate) FROM MembActivity WHERE MEMB_NUMB = "28686" GROUP BY Activity; but it generates the last date for...

Thank you for your reply. The Max function returns the most recent date, but I need the whole record for that date. The following generates an error (Activity is not part of an aggregate function): SELECT Activity, MAX(ActivityDate) FROM MembActivity WHERE MEMB_NUMB = "20686"; Could...

I have a Membership table which has a one-to-many relationship to a MemberActivity table. The MembershipActivity table lists activity and date for each entry. I want to base certain forms and reports on the most recent activity date for each member. Is there a function for this? Thank you for...