hi,
i have 2 tables..
tbl_sales fields (ID, Date, Empl_name, type, status, category, comments)
contains full list of all details that being sold per date.
tbl_specific_empl fields(ID, mainEmpl_name) contains only 5 specific employee name using it as list of values.
tables are independent..(attached data & tbls)
with this query getting error - at most one record to be returned by this subquery..
how to do that i get a list of record based only the specific values in tbl_specific_empl. via query and any code to add to the button in a continuous form 'btn_specificempl'
i have 2 tables..
tbl_sales fields (ID, Date, Empl_name, type, status, category, comments)
contains full list of all details that being sold per date.
tbl_specific_empl fields(ID, mainEmpl_name) contains only 5 specific employee name using it as list of values.
tables are independent..(attached data & tbls)
with this query getting error - at most one record to be returned by this subquery..
SELECT tbl_sales.[date], tbl_sales.[Empl_name], tbl_sales.[Type],
tbl_sales.[status], tbl_sales.[category], tbl_sales.[comments]
FROM [tbl_sales], tbl_specific_empl
WHERE tbl_sales.empl_name = (select mainEmpl_name from tbl_specific_empl where mainEmpl_name is not null);
;
tbl_sales.[status], tbl_sales.[category], tbl_sales.[comments]
FROM [tbl_sales], tbl_specific_empl
WHERE tbl_sales.empl_name = (select mainEmpl_name from tbl_specific_empl where mainEmpl_name is not null);
;
how to do that i get a list of record based only the specific values in tbl_specific_empl. via query and any code to add to the button in a continuous form 'btn_specificempl'
Attachments
Last edited: