You're absolutely on the right track with the set of books you bought. After borrowing these two books for the last year from a co-worker, I just ordered my own copies today. They just don't compare to any others! Good luck!
use the DOS redirection symbol ">>" to direct the listing to a text file, e.g.
DIR *.* >> FILENAMES.TXT
Then you can import this file into a table.
just to further clarify my example...my column headings are various values of the PriceGroup table. I want them to show whether they have any data or not. So I explicity name them in the last line of the query SQL as:
PIVOT <nameoftable.columnname> in ("<listofvaluesyourlooking...
Try this: Go into the SQL view of your query and add the last line as follows:
PIVOT tbPriceGroup.nr In ("SGS","GS","CGS","CLGS LFO","CLGS HFO");
where the list of the fields in parentheses are the columns you want displayed, whether they...
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.