I have a form that calls a query with a command button. The query tells me the most recent contacts I have made.
The query (which actually has a join to handle the 1:m relationship between people and the contacts made with them) is basically: SELECT Name, Company FROM Contacts WHERE ContactDate > #10/17/2005#; I have a text box in the form that supplies the date for the WHERE staement. I am using a querydef to rewrite the SQL to insert the date, but I've got to believe there's an easier way to do it. Does anyone have any ideas? TIA Far Farley ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<<attachment: winmail.dat>>
