Solved

Access Date Prompt in Query

Posted on 2013-01-11
2
232 Views
Last Modified: 2013-01-11
What I'm trying to do is that if the enter date is greater than or equal to [Entry Exit Exit Date], then result be "Yes" if not "No".

When I try the expression as is, I get no data results.

[Enter Reporting End Date]

End of Report Period is: IIf([Enter Reporting End Date]>=Format([qrySHOFamilySystemB]![Entry Exit Exit Date],"Short Date"),"Yes","No")
0
Comment
Question by:jbakestull
2 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 250 total points
ID: 38768821
try


End of Report Period is: IIf([Enter Reporting End Date]>=Cdate(Format([qrySHOFamilySystemB]![Entry Exit Exit Date],"Short Date")),"Yes","No")
0
 
LVL 61

Accepted Solution

by:
mbizup earned 250 total points
ID: 38768824
try this:

IIf(Format([Enter Reporting End Date], "yyyymmdd") >= Format([qrySHOFamilySystemB]![Entry Exit Exit Date],"yyyymmdd"),"Yes","No")

Open in new window

0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Documents and settings folder 30 78
Update a text value in another table 10 40
Sum with where criteria on a report 5 16
combo box query 6 8
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question