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!

  • Congratulations strongm 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. thebluesdog

    Use IF formula to compare dates and calculate third date column

    I think I have solved it myself: =IF([Revised Due Date]<>"",[Revised Due Date],IF([Due Date]<>"",[Due Date],""))
  2. thebluesdog

    Use IF formula to compare dates and calculate third date column

    I have a list, with columns for Due Date, Revised Due Date, and Real Due Date; Real Due Date is a calculated column based on the first two columns. When an item is added to the list, the due date can be entered, or, left blank. Once there is an entry in the due date column, an entry can be...
  3. thebluesdog

    How Can I Do a Range Lookup in Access 2010?

    PHV-Thanks for your quick respnose. Below is the expression I have in my query. My result says #ERROR. County Name: DLookUp("[county]","[t ip boundaries]",[t inventory from ip lookup].[ip address] & " BETWEEN [range begin] And [range end]")
  4. thebluesdog

    How Can I Do a Range Lookup in Access 2010?

    I have two tables. One table contains starting and ending IP address ranges, along with the associated county name for each range. The second table has a computer name, and an IP address. I want to be able to use the computer's IP address, to look up the IP range, to get the name of the county...

Part and Inventory Search

Back
Top