1 Reply by DMF

  • DMF
  • Member
  • Offline
  • Registered: 25-11-2010
  • Posts: 22

Re: Date

Using Access I want to determine all sample-events associated with a specific location on a specific date. I can generate the list of survey events for the location but as date is not available (only vague-date... I am not sure how to construct the date aspect of the query? How do you enter a specific date into an Access query of Recorder6?

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Date

Assuming you are using a direct link to Access then you can convert the Recorder vague date to a  string with the Access function CDATE and query against this. For example

SELECT CDate([VAGUE_DATE_START]) AS Expr1, dbo_SAMPLE.VAGUE_DATE_START
FROM dbo_SAMPLE
WHERE (((CDate([VAGUE_DATE_START]))="31/01/2000"));

Mike Weideli

MikeWeideli's Website