just need to know that if you have a table using VISdata as follows

Project Name
Initial Budget
Current Expenditure
Start Date
End Date

how do you show all the projects CURRENTLY being worked on using the start date and the end date??

data1.recordsource = "SELECT * FROM StaffDetails WHERE..................????????

Please help....just new to the world of databases in VB.... thanks!