Can anyone point me at a some basic bracket matching freeware please??
Having a mare with some old long SQL statements that I am trying to sort
out!!!
Regards.

Is there a way to get Access 2003 to get past the whole number limit for top
percent?
I'm crunching a large amount of weather data for a particular station (I'm a
meteorologist).

I have a table with 4 fields:
SONumber, InvDate, InvAmount, Complete (Yes/No field)
The table will have multiple records for many SONumber's. I need to
write a query that will find all SONumber's that do NOT have an entry

I am trying to construct a crosstab query to display product competition for
companies in a region, including reporting what cities do not have companies
selling that product, in other words, including records with no matches.  
Here is how my db is set up:

I am facing the wierd problem of cummulative addition.
the table looks like
[SampleID] [SampleDate] [ParameterTestMethods] [ParameterMethodCost]
[ParameterName] [ParameterTestCost] [ P_CoST]

In the query design window I have two tables:
"SumofSuppCost"
"SuppCost.
The aim is to supply the last cost paid for

I have a database with payroll records.  A sample of the data looks like this
Emp#     Adjustment      Code    Netpay
123         50.00              NT                 500.00
456         75.00              UB                 600.00

I have
iif(isnull([forms]![main]![programs]),like "*",[forms]![main]![programs]) as
criteria in a query field.  If I place a value in the field on the form the
report that uses the query with the above criteria works but if I put nothing

I would like to be able to run a query and get a list of ID numbers and from
that list of numbers use those as parameters to run another query.
Additionally, I would like to have this automated so user input is restricted
to parameters on the first query. Any help would be ...

i have an Access 2003 qry "qryP11"
Payment ID      Employee ID       Week Number      Pay        Pay to date
     1                      4                         1               100  
          100

I need to implement the following logic in a report column in Access 97:
IF hist_mis_cds!typgess = "", then calculated field= ""
ELSE
IF hist_mis_cds!typgess <> hist_code_translation! src_code_desc

I'm working on grouping individual records together by families, and I need
help creating a text field that is the combination of all records in the
group when the group has more than two records.
My query is below, you can see that I'm using the FIRST and LAST statements

Looking for the best way to do something.  Best can be easiest or best
practice - I'm up for either.  Don't need details (not yet :) - just a
general direction to start.
I have a table that tracks photography orders - one record per order.  I

I currently have several crosstabs, Querys & Forms.
What I need to find out is how to get the zero counts to show.  I am trying
to add up people assign to a phone skill at what priority they are assigned.  
EX. I'm showing:

I need to design a process that will show a rep his/her top ten customers
based on sales increase from the past 60 days comapared to the same time
period from the prior year.  I also need to show a rep his/her bottom ten
customers based on decrease from the past 60 days compared ...