Access database query

Results 1 to 3 of 3

Thread: Access database query

  1. #1
    Join Date
    Dec 1969

    Default Access database query

    I&#039m trying to query an access database for all entries made within the last week. The problem I&#039m running into is if it&#039s at the beginning of the month it has problems with going back to the previous month. How do I fix this or get around it?<BR><BR>Andre

  2. #2
    Join Date
    Dec 1969

    Default RE: Code please...

    Could you give us an example of the code you are using?

  3. #3
    Join Date
    Dec 1969

    Default RE: Access database query

    Dim SDate<BR>Dim EDate<BR><BR>SDate= Date()-7<BR>EDate= Date()<BR><BR><BR>"Select * From Table Where Date Between #" & SDate & "# And #" & EDate & "#"

Posting Permissions

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