Recent content by pinkapepink

Worked Great! Thanks!:p

I have a form which has a drop down box which links to a table with Employee names. One employee quit and I want to delete her name from the table. But... if I do that, I will delete her entirely from all previous records. Is there a way to keep all previous records, but take her out of the drop...

That worked! Thank you so much for your help!

I verified that Visual Basic Editor was checked. Query still will not work. Please see attached zip file. Thank you so much for your help! I really appreciate it!

SELECT [Project Request Table].[Project Request Number], [Project Request Table].[Project Date], [Project Request Table].[Client Name], [Project Request Table].[Account #'s], [Project Request Table].[Sales Rep Name], [Project Request Table].[Due Date], [Project Request Table].[Date Approved]...

Yeah, I did that. Still getting the error.

Thank you so much for the response! I tried your suggestion and when I check the datasheet, it says "Error#". I have no idea what to do now. :confused:

My table has fields for "Due Date" and "Project Completed Date". I am trying to build a query that will display either a "Yes" or "No" in a column titled "Project Completed Before Due Date" to help determine whether projects are being completed on time or not. I am new to Access, and I am...