Help with formula

[Guest]

I wrote the formula, if(B:B-365>TODAY()-365," Yes". "No") in Excel and it
worked how I wanted it to.

Now, I want to convert it into a formula for Access. I know I have to use
[column title] instead of B:B. Does anyone know if this is possible?

 

[Ken Snell \(MVP\)]

Where in ACCESS do you want to use this? In a query? On a form? On a report?
In VBA code? In a macro's Condition expression? Please provide us with more
information.

The Date() function in ACCESS is the "equivalent" to TODAY() from EXCEL.

 

[Guest]

What I would like to do is to be able to do is to put a date in a column and
then be ale to get a report of which dates are more than one year old.

 

[Guest]

What I would like to do is to be able to do is to put a date in a column and
then be ale to get a report of which dates are more than one year old.

And I would like it to give the word "No" instead of showing the date.

 

[Guest]

OK, scratch the last posts. What I have is names of people with dates next to
them. I would like to have a report show a list of the names whose dates are
older than one year.

 

[Ken Snell \(MVP\)]

A query with a calculated field may be what you seek:

SELECT Field1, Field2, Field3,
"Older Than One Year" AS Status
FROM Tablename
WHERE DateDiff("d", DateField, Date()) > 365;

 

[Guest]

One question: where exactly do I enter this?

 

[Ken Snell \(MVP\)]

You could use it (after changing the generic names of fields and table to
the real names) as the Record Source of a report.

 

[Guest]

What field should I make be Field1, etc.?
I have fields with LastName, FirstName, an IDNumber, and the one with the
date.

 

[Ken Snell \(MVP\)]

Those are just generic names. This query statement uses your field names:

SELECT FirstName, LastName, IDNumber,
"Older Than One Year" AS Status
FROM Tablename
WHERE DateDiff("d", RealNameOfDateField, Date()) > 365;

 

[Guest]

Now I have something else I'd like to do. I've added a lookup table column to
my table. I'd like to have it display the same message as the other query if
there is a value, any value, in this column.

 

[Guest]

Perhaps I could add an "or" condition to the original query?

 

[Ken Snell \(MVP\)]

Sorry, but I'm not understanding your question...