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...
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]")
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.