cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Todd
Engaged Sweeper III
Can somebody give me the command in a report so that only drive C shows up? For example, in the report about low disk space, how do I make it only show me drive C? I think this is the line for the drive letter?
tblDiskdrives.Caption

Another example would be when using tblEncryptableVolume.DriveLetter
How do I tell a report I only care about drive C.
1 REPLY 1
RCorbeil
Honored Sweeper II
If you just want to quickly filter the results of an existing report, type "C:" (without the quotes) in the filter box under the Caption column title.

For the reports that show the drive letters, such as "Disk: Servers less than 1 GB free HD", most of them will involve tblDiskdrives. Add to the WHERE clause on the report:
WHERE
condition
AND another_condition
AND tblDiskdrives.Caption = 'C:'

As far as tblEncryptableVolume goes, the field DriveLetter contains the drive letter in the form "X:". When you create a report that joins tblEncryptableVolume, you'll want to include
AND tblEncryptableVolume.DriveLetter = 'C:'
in your WHERE clause to filter the results for C: drive.

Refer to SQL comparison operators and SQL LIKE operator for information on how to do text string comparisons.