I am new to Jet and am connecting to a Nav and outside SQL DBASE.
I am currently retrieving data from the sql Dbase and only seem to be able to bring back all the individual values. I can then add sum functions or use filters on it but this is effecting performance as in some cases I am retrieving 50,000 lines. Can Jet just bring back the total columns so I get far fewer Excel lines? I have hidden the lines whch makes the report viable. The values I am retrieving are all numeric
Thanks for your help