File Searching Question

[DancerX]

Windows 10 Pro 64-bit
TP10 sp1 4011 (Registered for many years :-) )
M$ Access 2010

I have a database of hundreds of video files. In the Primary window I have each file showing the following:

1. Thumbnail image
2. File name
3. Rating (1-5 stars (*) entered in the Metadata Info box)
4. Length of video (User defined)

I'm unable to search based on Rating. When I click on the FIND button, I can find files based on file name, keywords, and length, but not Rating.

I'd like to be able to search for all files rated 3 stars, for example, or even files with NO stars (not yet rated). How can I do this?

I know it can be done because I've done it before. Sadly, however, I've forgotten what I did to do it. Can anyone suggest a way?

Thanks in advance for any help you can provide!

D

[Daan van Rooijen]

> I'm unable to search based on Rating. When I click on the FIND button, I can find files based on file name, keywords, and length, but not Rating.

Off the top of my head, it's in the Advanced tab of the Find dialog, where you can specify less often used database fields to search, including rating.

[DancerX]

Thanks, Daan, but I already tried that with this:

 tn.[rating] = ***

and got an error message:

Database error: <-3100*42000>

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '([TN].[name] like '%' AND ([TP].idVol]=2 AND [TP].[name]=Pa_RaM000)) OR (tn.[rating]=***)'.

I have no idea how to interpret this error. The Advanced tab appears to be for SQL statements only. I don't use SQL unless it's built into Access or TP10 in some way.

Your thoughts?

Thanks again for your quick reply!

[Daan van Rooijen]

Hi Dancer,

Yes, that's the right field. Try a numeric value 1-5, for instance:

tn.[rating] >= 1

(this should find all rated videos)

or

tn.[rating] = 5

(for all top rated videos)

[DancerX]

That did it!

I used numeric values (1 - 5) and found exactly what I wanted. I even used '0' and found all of my unrated files.

I'm a happy TP user again! lol

Thanks so much, Daan, for your help!

Be Well,
D