Query to fill up table for the day

saudkazia

New member
Local time
Today, 13:05
Joined
Sep 14, 2014
Messages
6
hi.

Suppose I have two tables Batch, Farm

Basically I want to create an append query so that for the day selected in a form tied to the farm table, I would be able to create multiple records based on the number of records in the batch table with no duplicates.

for instance. batch table has 1,2,3,4,5,6,7 for example

farm table should be appended with
date, 1, other fields
date, 2, other fields
date, 3, other fields
date, 4, other fields
date, 5, other fields
date, 6, other fields
date, 7, other fields

where date is the date selected.


I know this is vague but if someone can point me in the right direction it would be good.
 
If you just want to append the records from batch to farm with the date from the form then create an append query in the query designer and to add the date put in an expression that's a reference to the form textbox with the date. I suggest using the expression builder

attachment.php


You should end up with something like:

Expr1: Forms!TheNameOfTheForm!TheNameOfTheTextbox
 

Attachments

  • BuildFormReference.jpg
    BuildFormReference.jpg
    53.3 KB · Views: 167

Users who are viewing this thread

Back
Top Bottom