Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old October 26th, 2016, 06:42 AM
Anathil Anathil is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2016
Posts: 2 Anathil User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 26 m 27 sec
Reputation Power: 0
Access 2010 query exact date from field

Hi every one and thanks you for your help in advance

I have what seems to be a very simple problem.

I have a table with dates (Date) in a date/time format (dd-mm-yyyy)
and I have a form with an unbound field called "FindDateSpecific".

I am trying to build a query which would run when I press a button on the form with the unbound field.

My problem is that I cannot figure out how to set the criteria in the query to get the date I am writing in the unbound field in the form.

In the same form I have another unbound field called "FindYearSpecific" and in the same query I have:
Field - FindYearSpecific: Year([Date])
Table - Nothing
Sort - Nothing
Show - Check
Criteria: Like [Forms]![frmSearchGeneral].[FindYearSpecific] & "*"

This gives me all the records for the specific year I am after - If I write nothing it gives me every record in the table.
I want my FindSpecificDate field to work the same way.

In the form you should only fill one of the fields of cause But I want both options.

Anybody out there knows the solution? Please...

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Access 2010 query exact date from field


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap