Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PortlandSam

    Trying to replace Expired date fields with Null value

    Ok, lets turn it up a bit. Now that I have the previous working, I have discovered I have a need to give a null value on the update to a couple other fields on the same record, if it's date has expired. Any idea's on that?
  2. PortlandSam

    Trying to replace Expired date fields with Null value

    Works smoothly, easily, and perfectly! Thanks!!
  3. PortlandSam

    Trying to replace Expired date fields with Null value

    Hi All! I am trying to get a query to eliminate expired dates(Any date prior to the current one) from date fields, without removing the entire record from the table. I'm without a clue if this is even possible, and am having trouble figuring out how to get started on this. All help is warmly...
  4. PortlandSam

    Reporting "N/A" whenever a numeric control field is null (blank)

    That worked perfectly, thank you! And now that I have that part working, I have found out that was not the source of my problem. I have a report using a query that draws from a form that has narrowed down my tables to a single record, and my desire is to export my report of that record into Word...
  5. PortlandSam

    Reporting "N/A" whenever a numeric control field is null (blank)

    This post sounds like it may be the solution I am looking for, for my report, but I don't know how to use CajunCenturion's code; =IIf((Len(Trim(Nz(<FieldName>,&quot;&quot;)))=0),&quot;N/A&quot;,<FieldName>) When my current control source is allready this; =Forms![Hourly Non]![STD GRP ID] Any...
  6. PortlandSam

    MS Converted report won't convert all fields if any are null!

    Hello Legions of Helpful! I have a report with about 25 fields that I am converting into a .rtf Ms Word format, and it seems that if any of the results in the query are null, it converts all the field titles, but none of the data. If all fields have been populated by the query, then it converts...

Part and Inventory Search

Back
Top