Here's my problem: Sales tax= If a customer lives in CA, calculate the sales
tax as 7% otherwise calculate sales tax as 5.5%. How can I build a
calculation expression in a query to do this?

I created a form from a query, and I would like users to be able to
select the key field from a combo box in order to find the record they
want to edit. I went into the "Properties" of the column in Query
Design view.

I know that an error will occur when setting up a Query to display Distinct
records of a Memo field.  I also know that there is a work around this, which
involves referencing the original table containing the memo field.
My problem is as follows.  I have a table containing 3 ...

SELECT Patrols.Level, Events.[Event Name], Patrols.[Patrol Name],
Patrols.Troop, [Score]![Score]*0.75+[Score]![Sprit]*0.25 AS Expr1
FROM Troops INNER JOIN (Patrols INNER JOIN (Events INNER JOIN Score ON
Events.[Event ID] = Score.[Event ID]) ON Patrols.ID = Score.[Patrol Name]) ON

I have a table and query for an index. The index runs from .0000 to .995.
There can be many different numbers of decimal places, like .333560000 or
just .4.
The are 250 numbers in the index and school districts are given an index

I am trying to extract data from a SharePoint list that are of type
multivalue.  I am able to extract the data correctly from a single column
using [Column].Value in my select statement.  However, I have 32 multi-value
columns in the table that need to each be converted into a ...

Below is the query that returns everything I want to see but I wish to have
the column headings to be like "Mar 9-16" as that would allow me to copy and
paste into Excel with greater efficiency and integrity.  Currenty the column
headings are 1,2,3,etc so I would need to format ...

I have a set of data.
In the field there are datas such as
Diet, Health
Diet, Non-Fiction

Hi I have a crosstab query that only has two records. It is a very
simple query with a sum field that is working for one of the records
but not the other. Here is my SQL
TRANSFORM Sum([99_02_Report - EIP Asset Value Summary].Net_Assets) AS

I am trying to change zero-length strings to Null on a table. How do i
do this.

I want to translate a document into French do you have to pay World Lingo for
the translation or is it a free service?

I have a problem. I'm trying to do two things with my data that
apparently can't be done together.
The context is an assessment system, where scores for each question
are recorded over time on a 1-5 scale. Questions are assessed at

I upgraded from 2000 to 2007 and I have an update query that I cannot edit.  
In 2000 it was :  Replace([tblHyperlinkUpd].[TR_ELCO],"M:","#M:")
2007 changed it to :Replace([tblHyperlinkUpd].[TR_ELCO]|"M:"|"#M:")  2007
changed the , to |.  Now I can't change the | back to a  ,  .    ...

I found this response in a post regarding a query I'm trying to do. It looks
like it's what I need but I don't know how/were to implement it in the query.
what I found
Hi,

I have a main form with Customer Info, and a subform with invoices.. they are
linked with the custID.
I would like a 'goto invoice' text box.. This would when cmdGoTo is clicked
take the value of the text box, search the subforms InvoiceID field and show