Search results

Thank you for the idea, but it didn't work. I get the following error: "You entered an expression that has an invalid reference to the property Form/Report. The property may not exist or may not apply to the object you specified." I tried a bunch of things with this and none are working...

Good evening, Thanks in advance for any assistance! I have a report called Recent_Update_Items, within this report is a subreport Recent_Notes_subreport (subreport has 3 fields: Assignee, Note Date, Note). The reports are linked by the Project ID. The main report contains information about a...

Hi, I have tried several things with adding additional conditional statments to my query, however, have yet to make it work. I will revisit it tomorrow. Just wanted to say thanks for all of the input. I will get it to work eventually!

Hi! You could have it hard coded in: =[name] & " - " & [price1] & "$" Or you could format it specifically: =[name] & " - " & format([price1], $#,###.00) Hope that helps!

Hi, thanks for your post! To be more clear, I have a form that allows the user to select All or Specify for each of the criteria (SSN, First Name, Last Name and/or Active Date Range). Some examples of selections and return would be: Example #1 User selects All for SSN, All for First Name...

Thank you for your input, however, it does not work. If I enter nothing in the FromDate and ToDate, it returns no records (I would like it to return all). If I enter dates in these fields, it returns all records, not just those within the requested date range. I appreciate your help! I am...

Hi all ~ help please! I have four fields in a query which will allow a user to specify or just show all. Field Names and Current Criteria: Soc Security Num = Like [Forms]![ACT_RPT_OPT]![SSN_Select] & "*" First Name = Like [Forms]![ACT_RPT_OPT]![FN_Select] & "*" Last Name = Like...