Fill Table control

[Gasman]

we will be decommissioning the program soon so i will net get any assistance to get a report with the data i need

thank you for your assistance, much appreciated

That does not matter.?
Unless you can define a set of rules for the data, it is never going to work?

My rule was that the header has an item number of 0 and an interval id of "O", or so it appeared, so with that rule it updated 750 rows for the child records as you can see. Where the tem number was 0 and the interval ID not "O" it did not update?

Here is another example

 

[Gismo]

This may be of interest, but not sure what you are doing.

Access Fill Down to Emulate Excel Fill Down

Recently there was a user trying to emulate the Excel fill down functionality based on imported data. I am re-posting this solution here since I could see some utility and this may be a common issue. The OP mentioned doing several web searches and not finding an easy solution. The solution...

www.access-programmers.co.uk

Hi,

looks like what I need, thank you, will give it a try

 

[MajP]

It will work but in this case you need to first move the headers into the field. That can be done with an update query where column h = o. Then you can run the fill down.