Celeste-
In a query, add this on the Fields line:
RecivedBeforeLoss: [Date Received] <= [Date of Loss]
If you also want to filter to show only these rows, add Date Received to the Fields line and put this on the Criteria line:
<= [Date Of Loss]
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 28, 2014, at 5:03 PM, celestecpa <no_reply@yahoogroups.com> wrote:
I have an Access data base with several fields using dates. I need to find out if DATE RECEIVED is less than or equal to DATE OF LOSS. Can someone help, please? Would I use a query? Do I put the expression in the Criteria? Do I put a VBA expression in the properties? How would I get, let's say, the word "True" in another field if the expression was correct? I need to run this for 12,000 line items.
I appreciate any help you can give me.
Thanks in advance,
Celeste
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar