[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access Date Prompt in Query

Posted on 2013-01-11
2
Medium Priority
?
240 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 1000 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 1000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

834 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