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!

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

Generate records in a related from a query or VBA???

Status
Not open for further replies.
DorenM

DorenM

Programmer
Mar 4, 2002
5
US
Hello! Hope someone out here can get me going in the right direction. I'm trying to create journal entries based on the number of months between two dates, the beginning and end of a contract in the CONTRACTS table. I want to generate a record for each month a contract is active and post a dollar amount on each record in the Contracts_Detail
table. (MORE DETAIL: A contract active from 01/01 to 06/01 for $6,000 should generate entries in the ContractsDetail for field-value: Rec-1, Date-01/01, Amount-$1000; Rec-2, Date-02/01, Amount-$1,000; etc through Rec-6, Date-06/01, Amount-$1,000. The "Rec-x" values aren't important, but the other two field values are.)

Is this a VBA solution or an append query solution?

Thanks so much for your help! :)
D.
 
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
13
Views
440
strongm
strongm
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
257
mikrom
mikrom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
895
serino
serino
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top