Ignore Blank Parametres In Query

Hey

I have a form where the user can choose from a drop down menu, values like Name= James.90
Date=1/10/07.


Then it would return the record with James.90 And That date in it

But my problem is you have to choose a value for both boxes. Is there a way to ignore it if the field is left blank.

My current code is


SELECT timesheet.WeekEnding, timesheet.FName, timesheet.Company, timesheet.Project, timesheet.CTR, timesheet.Comments, timesheet.Total, timesheet.Project_Title
FROM timesheet
WHERE (((timesheet.WeekEnding)=[Forms]![FormBeta]![Week]) AND ((timesheet.Company)=[Forms]![FormBeta]![Company]) AND ((timesheet.Project)=[Forms]![FormBeta]![Project]));