Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by drummerian

  1. drummerian

    Adding Multiple Records

    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'
  2. drummerian

    Adding Multiple Records

    how does this add multiple families?
  3. drummerian

    Adding Multiple Records

    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...

Part and Inventory Search

Back
Top