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: *

  1. danielmurray

    ntbackup and command line!?!?! grrrrr!

    I know this is a little late, but we are just now upgrading from NT4 to Win2K. The problem is that the parameters for Win2K NTBACKUP have changed significantly. Go to the Help system for NTBACKUP and look up "Command Line". You cannot use a /d description, and may have to use a...
  2. danielmurray

    Pictures take too much space!

    I have an Access 97 database that stores pictures of people.&nbsp;&nbsp;The table is setup with the picture field defined as an OLE Object which links to the actual picture file, for example c:\xyz\abc.jpg<br><br>When I start loading up the database with pictures, it starts to increase in size...
  3. danielmurray

    Crosstab Query without duplicates?

    Thanks for your response. Great idea.&nbsp;&nbsp;I considered that, but wanted to avoid messy database operations that might impact the database integrity in the long run.&nbsp;&nbsp;If I need a temporary table, I have tried to use a permanent table that simply gets cleared upon each use. If I...
  4. danielmurray

    Crosstab Query without duplicates?

    Thanks for your response. I guess what I didn't make clear was that in this database there indeed is a separate field for gender, but there isn't a single AssistanceType field as you documented.   I have a one-to-many relationship where one client record can have many assistances, each with...
  5. danielmurray

    Crosstab Query without duplicates?

    I need to create a crosstab query to count client ages by male and female.&nbsp;&nbsp;This is part of a much larger report with lots of selection criteria based on date assisted, type of assistance, etc.&nbsp;&nbsp;I have a working select query to remove any clients with repeat assists.<br><br>I...

Part and Inventory Search

Back
Top