I am trying to run a query where it is important to get the result of 0,
instead of Null.  Here is a simple example of how my query looks now.  Table
is "Master Sales Data" and the field is "Sale DIGI":
SELECT Count([Master Sales Data].[Sale DIGI]) AS [CountOfSale DIGI]

Hello...
I need a query written that will do the following...
If column A is NULL and Column B is NOT Null,  Then move (not copy) column B
to Column A.

I have this query:
SELECT MyDate, count(Diagnosis ) AS MyCount
FROM TblTherapy
WHERE Diagnosis like '*myText*'

In an Access database query I have a table/ query with values per week (52
weeks), shown in 52 columns.
I can't find the right way to find to the summary; average and Max -value
within a row.

I have 2 table and fields as below
Table A has 2 fileds       Table B has 1 field
val1            val2                      valRef  
All 3 fields is integer data

So powerful but sooooo frustrating.
In a Select query I have a calculated field that contains
LOS: DateDiff("d",[A_Date],[D_Date])
A_Date and D_Date are, in turn, calculated fields (they use left(), mid()

I have a date format of, 01 11 2006 in the column.  I need to change it to
where it is 01/11/2006.  I tried to write an update query for this but not
sure how to add the "/"?  Any help would be appreciated.

I have two tables, contacts and companies, which are related by the companyID.
The value in the contacts tables is a result from the input form where for
avery contact one can choose the company using a combobox.
Now I would like to populate a list box using a query which as input ...

Can someone tell me if there is an easy way to utilize a different field name
for a coulumn heading in a crosstab query?
Issue: I have developed a Trip Database. I have created crostab queries to
view who participated in each trip with total count of participants. I was

I've a db that records diferent values of an event in diferent dates for
severall persons, and I want to know:
1 - All the average value between dates (ex: (Value2-Value1)/(Date2-Date1)
for each person)

I´ve got one question. Is there any posibility to make chained data values?
For example, I´ve got fíve values, which means increase in value in time
5
0

I'm using northwinds and my teacher wants us to explain the relationships
between each query (individually). Example Query: Alphabetical list of
products, this query has two tables Catergories and Products Now I see that
these two tables have a relationship, how do I explain a ...

I attempting to do the following
Subeve: IIf([RDCIS]![DCI_NAME]="Page_03a","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_04","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_07","0" & [RDCIS]![SUBEVENT],"")

I want a query that ask the date range and give you a total count. This is
what I've got:
Field:ProficiencyCompletionDate
Table:CompletionQuery

I have a date input field.  I would like to run a query that allows me to
choose a date range and have it return all records whose date input field
fall into that range.  i.e. from 4/2/2007 through 4/6/2007.
I can't seem to figure out the expression...