For comparing afterwards:

select a.payment, b.payment from ( select * from [i:\d\z3756\agdb\soils.mdb].ssFY2 where payment = 'Online Submission' ) a inner join ssFY2 b on a.lab = b.lab order by 2

select a.payment, b.payment from ( select * from [i:\d\z3756\agdb\arch.mdb].waFY2 where payment = 'Online Submission' ) a inner join waFY2 b on a.lab = b.lab order by 2

For testing afterwards:

select Lab, Name, Requested from FEWLoginAFY1 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) and not void and lab = round(lab) order by Lab
select * from SSFY1 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from AnFY1 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from PlFY1 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from SpFY1 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from WaFY1 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from CoFY1 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab

select Lab, Name, Requested from FEWLoginAFY2 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) and not void and lab = round(lab) order by Lab
select * from SSFY2 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from AnFY2 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from PlFY2 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from SpFY2 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from WaFY2 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab
select * from CoFY2 where date < #DATE# and (payment & '' in ('', 'cmi', 'paid', 'approved')) order by Lab