asked on I need to convert this SQL statement to a MS Access 2003 SQL Query
I need to convert this SQL statement to a MS Access 2003 SQL and I cannot make it work. I have never used a subquery and I assume this is what I require.
Any help?
No. 1
Select count(*) from PXDTA.F31P01 where PAPRJM in(select wadoco from pxdta.f4801 where wadcto=”ET” and wamcu=wammcu)
No. 2
Update PXDTA.F31P01 set PAJBIF=0 where PAPRJM in(select wadoco from pxdta.f4801 where wadcto=”ET” and wamcu=wamcu)
Help appreciated. I cannot seem to get my 70 year old mind functioning today.
tw
Any help?
No. 1
Select count(*) from PXDTA.F31P01 where PAPRJM in(select wadoco from pxdta.f4801 where wadcto=”ET” and wamcu=wammcu)
No. 2
Update PXDTA.F31P01 set PAJBIF=0 where PAPRJM in(select wadoco from pxdta.f4801 where wadcto=”ET” and wamcu=wamcu)
Help appreciated. I cannot seem to get my 70 year old mind functioning today.
tw
Microsoft AccessSQL
Last Comment
Tom Winslow
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
When you get to be my age (70), stuff that used to work well don't work so well amy longer. Sometimes I cannot see the forest for the trees.
Thanks,
tw