Unanswered: Date covered by from / to date
I'm really having a haggle here with Access, as I would solve this in a jiffy using SQL-Server.
I have two fields in a record, a FROM date and a TO date.
I need to do a query that checks if a given date (this case 31/12/05) is inside the range defined by the FROM date and TO date.
How to do so in Access?
Is an example of it...
WHERE (((#12/31/2005#) Between [dbo_Plademærkelinie].[Fra dato] And [dbo_Plademærkelinie].[Til dato]));
Last edited by Trinsan; 03-21-06 at 05:15.
IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....