Results 1 to 2 of 2

Thread: how to use commands for dates in a data environment ?

  1. Sep 18th, 2003, 06:09 PM #1
    michel Femi
    michel Femi is offline

    Thread Starter
    New Member
    Join Date
    Sep 2003
    Location
    brazzaville, rep of Congo
    Posts
    1

    Question how to use commands for dates in a data environment ?


    hi friends,

    i'm making a software that manages customers of a clinik (i'm using access database).

    while using the data environment, i have encountered difficulties to use sql instructions that allows the data environment to display ONLY data matching with the current month. please i invoque the deep of your knowledge to help me.
    Last edited by michel Femi; Sep 18th, 2003 at 06:13 PM.
    Reply With Quote Reply With Quote
  2. Oct 2nd, 2003, 12:27 PM #2
    spud
    spud is offline
    Fanatic Member spud's Avatar
    Join Date
    Aug 2000
    Location
    Munster (Germany)
    Posts
    542
    michel,


    "Select * From (your data Sheet) WHERE Date Between #" & Text1.Text & "# AND #" & Text2.Text & "# order by date "
    Haven't got anything to say that is the least bit interesting.
    www.tartan-underground.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width