Hello,
Any help would be greatly appreciated! I want to create one append query but figured out the results are wrong. I have several linked tables, some used more than once, that calculate the average time between two fields on two linked tables. If I create an append query for each average i want to calculate, it works fine but I want to condense since I need to calculate for 6 averages. So, I just want to have one append query because I am only appending to one table. Do you think it has something to do with the query already being run once that it will not supply me with the correct information since it needs to be used in a different calcluation?
Thanks for any input.