mulitple search queries to display records from access database

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Sep 2009
Posts: 1
Reputation: rahulsaigal is an unknown quantity at this point 
Solved Threads: 0
rahulsaigal rahulsaigal is offline Offline
Newbie Poster

mulitple search queries to display records from access database

 
0
  #1
Sep 22nd, 2009
hello ,
i have the following accessdatabase
access database name = surya
table name = collection
field 1=id
field 2=date
field 3=customer
field 4= amount

i want an asp code were i will input
from date
to date
to search the table collection and to display all records in between from date and two date

pls help as i m new to asp and am trying to develop an application

thanks
rahul
Reply With Quote Quick reply to this message  
Join Date: Mar 2007
Posts: 305
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 25
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz

Re: mulitple search queries to display records from access database

 
0
  #2
Sep 23rd, 2009
It sounds like all you need is to build a query and use the WHERE clause. Doing a quick search will give you plenty of examples.
Reply With Quote Quick reply to this message  
Reply

Tags
searchdatabase

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC