show results of search

Results 1 to 2 of 2

Thread: show results of search

  1. #1
    Join Date
    Dec 1969

    Default show results of search

    i have a database which records the hour that staff have worked any i would like to create a search that would allow me to search through the db for the hours that each staff member has worked. hours are recorded week by week using the sysdate entered in a field in db, and totaled each month, so i would like to search through the db using various periods of time, ie one week, 2 weeks, 3 weeks , 4 weeks. is there any way that i could show these option in a dropdown and from the users choice then produce that data on screen.<BR>i am using vbscript and access.<BR>any examples of such code would be greatly appreciated.<BR>thanks.<BR>bob

  2. #2
    Join Date
    Dec 1969

    Default Just reload the page...

    .. submitting the form.<BR><BR>You can then build the SQL statement pretty easily using DateDiff.<BR><BR>-Doug

Posting Permissions

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