Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: SuzieQQ
- Order by date
-
Form size reduction // 19" screen to 15" screen
I had the same problem with two of the same-size monitors but the 2nd monitor had different setting, e.g. 600 x 800 versus something different.- SuzieQQ
- Post #3
- Forum: Microsoft: Access Other topics
-
Would like to learn design techinque
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!- SuzieQQ
- Post #12
- Forum: Microsoft: Access Other topics
-
File Names
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.- SuzieQQ
- Post #2
- Forum: Microsoft: Access Other topics
-
Crosstab Queries Driving Me Crazy!!
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...- SuzieQQ
- Post #7
- Forum: Microsoft: Access Other topics
-
Crosstab Queries Driving Me Crazy!!
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...- SuzieQQ
- Post #6
- Forum: Microsoft: Access Other topics
