I WANT TO ONLY SELECT 10 SPECIFIC ITEMS AND WANT TO PULL ONLY ORDERS THAT HAVE ALL TEN OF THESE ITEMS ( NOT ORDERS THAT HAVE ANY OF THEM BUT ORDERS THAT HAVE ALL OF THEM)
I could have 3 or more invoices for one account..I want to know the number of days between each invoice..each on a separate line and show each line..please
Thanks..that helps..Think we'll test Visual Foxpro..now with Foxpro 2.6 we can manipulate the data in Foxpro for a complex report and then go to Crystal to finish some of the things Foxpro won't do..or use Access.
Thanks again..
Actually I am researching..we now use Foxpro .dbf files which we download each night converting from Betrieve Dat files. Looking to get off of Foxpro. My larger table has
20 fields and the smaller one about 70 plus we then access 4 or 4 other tables in order to bring in other information...
I want to join 2 files by order# and select a status and an entry date..one file is 234M and one 1.7 G..what else do you need to know? I want to know if it is feasiable to use Access for this type of query..Thanks
The file I want to use are about 1.7GB Can Access handle that size file without taking a long time to process..If so how do you deal with that issue please.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.