Enclosed in the attachment is a small database in zip format.
Have problem deleting records from a table.
The delete query F_DELETE_RECORDS_IN_T_EMPL
OYEE_PAYOU
T_FIRST_HA
LF_3 won 't run.
Error Message: Specify the table containing the records you want to delete
OBJECTIVE OF THE DELETE QUERY:
Delete all records in the table T_Employee_Payout_First_Ha
lf where the field counter = 41569
AND Employee_ID = 23456789 AND Year_And_Month_Period = Second_Half_of_2007
HOW TO TEST THE DELETE QUERY:
1) Open the form Search, and select Second_Half_of_2007 from the top combo box.
2) Run the query F_DELETE_RECORDS_IN_T_EMPL
OYEE_PAYOU
T_FIRST_HA
LF_3
//////////////////////////
//////////
//////////
//////////
//////////
//////////
//////////
//////////
//////////
//////
Query Name: F_DELETE_RECORDS_IN_T_EMPL
OYEE_PAYOU
T_FIRST_HA
LF_1
Counter Year_And_Month_Period Last_Name First_Name Employee_ID
41604 First_Half_of_2007 Red John 23456789
41604 First_Half_of_2007 Red John 23456789
41604 First_Half_of_2007 Red John 23456789
41604 First_Half_of_2007 Red John 23456789
//////////////////////////
//////////
//////////
//////////
//////////
//////////
//////////
//////////
//////////
/////
Query Name: F_DELETE_RECORDS_IN_T_EMPL
OYEE_PAYOU
T_FIRST_HA
LF_2
Counter Year_And_Month_Period Last_Name First_Name Employee_ID Second
41569 Second_Half_of_2007 Red John 23456789 Second_Half
//////////////////////////
//////////
//////////
//////////
//////////
//////////
//////////
//////////
//////////
////
Query Name: F_DELETE_RECORDS_IN_T_EMPL
OYEE_PAYOU
T_FIRST_HA
LF_3
Error Message: Specify the table containing the records you want to delete