another SQL syntax for AccessDB in VB

[Wajiha]

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!

[Hack]

My suggestion would be to add a field to your table called Status. Appropriate codes could be entered into this field which would designate the current state of each project.

That would make finding what you needed to find much more simple.

[agent_008]

ok... Let's try that SQL string:
SELECT * FROM StaffDetails WHERE something (your record) BETWEEN #Start Date# and #END DATE#