Excel

[vaughan198]

Hi there I am having the following problem.

I have a database where every day I import a report into three tables (unverified, unallcoated and TMQ).

I have three queries that return the most recent records by running another query first to get the most recent report date. When I run the querys induvidually it all works fine.

The issue that I have is that when I try to run them in a code to export them to excel it all works fine except that it does not run the subquery first to return the most recent report date and it just exports all the data from the table.

Any help would be hugely appreciated.

Thanks,

Will

 

[NigelShaw]

Hi

Well, either a code example or db example would help for a start. Unfortunately we here at AWF are willing to help and advise but in to do that, we cannot just guess at what you might have done.

Post something and we can help further


Nidge