Hi,  I have a Crosstab Query created which pulls the count of column 1,
column 2, column 3, and Total of 1,2, and 3.  What I want to do now is create
new columns in the Crosstab Query showing the percents for column 1,2, and 3.
i.e. cnt_1:Int(([1]/[Total Of cnt])*100)

The statement below will report N/A if VarWComm is less than 0:
AmtOfLoss:
IIf([QryClassActRpt.VarWComm]<=0,Format([QryClassActRpt.VarWComm],"Currency"),"N/A" )   
The statement below will report N/A if BuysSellsmatchYN = No:

I have a memo field that has html characters/tags and a lot of line breaks.
I've been using REPLACE nested about 8 deep and I'm still not getting
everything nuked. What's the easiest way to strip all that stuff and leave
only the text? Is there a function that will do this?

I received a request for this function, which I had offered to provide in an
earlier post here.  Rather than send it just to the person who emailed me,
I'm providing it here.
Call the function with 3 parameters, none are optional.  The first is a

I’m using a the fConcatChild function posted at
http://www.mvps.org/access/modules/mdl0004.htm to return a field with several
values from the Many table of a 1:M relationship in a comma separated format.
I’m using the function in a query and then combining it with another query

Hi All,
I have 2 tables that look like the following
ID,   SDate,   EDate,   OIN
1     071105  081105  123

I have a query that I use to return transactions that happened between a
specific set of dates, and the person responsible for those transactions. It
worked fine for a few months, but now returns odd results. For example, if I
select a date range of 09/01/05 to 09/30/05, it also ...

Not sure if posts buried far down in threads started yesterday are picked up
as new, so I am going to start another one - Tell me if this is wrong
procedure.
Anyway further to my post yesterday with the count unique subject, I am

For this I have been searching........................
Table 1 - ORDERS
OrderId    Customer   OrderMonth    OrderValue
Ord1        ARTC         Jan-06           250,000

Hello and Merry Christmas.
Here's my deal:  I know how to run a paramter query.  What I want to do is
expand a parameter-like query to allow me to select an item from a list of
items (like Last name, for example), and then have the query run and give me

I am using MS Access as database for filtering, sorting and exporting data in
order to prepare data for another program. This other program is rather old
and requires sorted data in input file. For this I have being using
Make_Table Query which filters data, orders it and saves ...

I have a field in a table as single and the results is to 3 decimals for all
records, for examploe 2.469.
When I use a query and I sum this field the result come to 2.49600005149841.
Why?

Not sure if this can be done, but I have a table with about 10,000 records
in it, all have a Main ID#, I need to replace about 80 of the records
(various Main ID#s) with records having the same Main ID # (these records
were updated elsewhere, and now I want to replace the ...

I have a table with a month order field in the format 200511 200510 200509
etc and a seperate table with an appropriate decode Nov 2005 Oct 2005 Sep
2005 etc
I want to do a Crostab based on the last twelve months data and I have set

I have inherited a database that has previously been designed by
someone else.
Example:
ID    NAME           SCR_DT                  SESS_DT