Using a wildcard when searching for an amount

Aug 26, 2006 5 Replies

Does anyone know how to use a wildcard in searching transactions for an amount?



For example, I want to find all transactions in the 700 dollar range $700.00 - $799.99 using a wildcard (an asterisk *).



My problem is that I know what I'm looking for (buried somewhere in my register with thousands of transactions) is an amount in the 700 dollar range but I don't know the exact amount to search on.



My thought is I'd like to search on $7**.** but that doesn't work using the amount field when I press * I get the calculator - and using "all fields" with the wildcard I get "No matching transactions" because Quicken is seeing the asterisk * as a literial character. Just searching using a single 7 brings up 9375 transactions - way too many to look through.



I tried looking in help using "wildcard" as a keyword search. I even went to Quicken's website and just hit a brick wall - so I thought I' try the user's group here on Google.



Please help. Thanks.



P.S. I'm using Quicken 6.0 Basic Release R 4



Cathy:

Have you tried searching using the "Starts with" criterion, instead of "Contains"?

Bob

For example, I want to find all transactions in the 700 dollar range $700.00 - $799.99 using a wildcard (an asterisk *).

My problem is that I know what I'm looking for (buried somewhere in my register with thousands of transactions) is an amount in the 700 dollar range but I don't know the exact amount to search on.

My thought is I'd like to search on $7**.** but that doesn't work using the amount field when I press * I get the calculator - and using "all fields" with the wildcard I get "No matching transactions" because Quicken is seeing the asterisk * as a literial character. Just searching using a single 7 brings up 9375 transactions - way too many to look through.

I tried looking in help using "wildcard" as a keyword search. I even went to Quicken's website and just hit a brick wall - so I thought I' try the user's group here on Google.

Please help. Thanks.

P.S. I'm using Quicken 6.0 Basic Release R 4

How about clicking on the PAYMENT column header, scroll down to the first $700+ entry, and simply sroll through the transactions until you see it?

"cathyblanton" wrote

I hope this is Q2006, R4.

No, you can't use wildcards in amounts, but it should not be necessary.

Create a transaction report for the account, sorted by amount. (You might also select only transactions less than $800 - on the Advanced tab - to reduce some of the extraneous clutter).

"John Pollard" wrote>

I forgot to add that if you know you are looking for a "payment", you can also include only payment transactions - using the Advanced tab. (Likewise if you were looking for a "deposit", or an "unprinted check".)

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required