Home Page link  

Using a wildcard when searching for an amount

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Using a wildcard when searching for an amount cathyblanton 08-26-2006
Posted by cathyblanton on August 26, 2006, 11:49 am
Please log in for more thread options
 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


Posted by Bob Wang on August 26, 2006, 12:06 pm
Please log in for more thread options
 Cathy:

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

Bob

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



Posted by cathyblanton on August 30, 2006, 9:17 am
Please log in for more thread options
Thanks Bob - Using "Starts With" worked just fine for my situation. I
appreciate the feedback.

Bob Wang wrote:
> Cathy:
>
> Have you tried searching using the "Starts with" criterion, instead of
> "Contains"?
>
> Bob
>


Posted by Andrew on August 26, 2006, 12:12 pm
Please log in for more thread options
cathyblanton wrote:
> 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


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?

--
-------------------------------------------------------------
Regards -

- Andrew



Posted by John Pollard on August 26, 2006, 12:47 pm
Please log in for more thread options

> 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

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).



Similar ThreadsPosted
AMOUNT INVESTED February 18, 2007, 11:22 am
FSA amount can't be negative? January 18, 2008, 7:36 pm
"Amount Invested" column in reports October 30, 2006, 4:55 pm
2007p "Warning: The amount of disk space on drive C is very low..." August 24, 2006, 8:12 pm
Editing Bill Reminder Problems (Variable Amount choices greyed out) September 20, 2008, 12:43 pm
How to change Cash Amount and Cash Balance in Q2008 Investment Acct? January 1, 2008, 9:34 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap