ahh i think i see, so would i have:
INSERT INTO SubsOwed ([Table].[Family].[FamilyID], [forms].[frmUpdateSubs].[termid], [forms].[frmUpdateSubs].[owedfrom], 0)
SELECT FamilyID
FROM Family
WHERE f1 = 'X'
Hi ppl,
Basically i want to use a query to add multiple 'blank' records to a table. I have a family table (each family has a unique family ID) and i need to put a blank record into a payments table (say once a month) with their family ID and the current amount paid as 0 as well as some...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.