Results 1 to 2 of 2
  1. #1
    PaulLuke
    Guest

    Between two dates

    Hi...everyone,

    I need to be able to create a database which I can query for work that was done between two dates. The information extracted will be used for invoicing and payroll.
    I am just now collecting the information I will need. I will use ASP to build the forms since the data has to be queried online (Internet)
    I am using Access 2000 and will upsize to SQL later. So....does anyone have any suggestions on how to build the table for this.
    Thanks for any suggestions or directions to where I can get code for this.

    Paul Luke

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Between two dates

    What I have done is not pure ASP, but FrontPage databasing. I create my queries in Access with "test" data in the criteria field to confirm that they work. Then I replace the criteria with variable names that I pass to the queries using FrontPage database functions. I recommend you start the same way, bearing in mind that your life will be simplest if you make only one call to your database (so nest your queries as deeply as needed).

    Then visit the ASP databases discussions at p2p.wrox.com or another ASP site for the down and dirty. I recently started reading this board, and there are lots of helpful folks:

    http://p2p.wrox.com/scripts/lyris.pl?enter...ses&text_mode=0

    Or you can "cheat" as I did with FrontPage. It runs! Fast!

Posting Permissions

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