I have a make table query that creates a large dataset called
2007_data_source.  In that query  there are only field values no
calculated fields.   I need a calculated field called amt_paid.  Here
is the calc:

We're using Access 2002 with links to tables in a server-based msd.
We've come across a problem dealing with an expression within a query.  The
syntax for the expression boils down to:
IIf(conditionA,resultA,[else] IIf(conditionB,resultB)) &

I am using a crosstab query as the record source for a report and my
problem is that I don't know how many columns the query will actually
return because the number of different values in the column used for the
crosstab will vary depending on the parameter values passed to the

I have a database of about 55,000 company names.  Different people at
different times and places made these entries.  Some have a comma before the
"inc.," some do not.  Some have periods between the letters LLC and others to
not; and some of those may or many not have the comma.  ...

I have a table with the following fields:
Date
Time
Telephone Number

I have a field that was returned to me from the State that now has multiple
records for each person.  Each person in my primary table has an ID that is
the Primary key.  I need to merge this new data with my current data
maintaing my Primary Key field.  The fields are:

I will try to provide as much info as possible without making my question too
complicated...
I have a search form based on Allen Browne's search form, which works great.
The form's source is a query (provided below).

Perhaps someone can enlighten me.  I am relatively new at creating SQL from
scratch. If it gets too complex, I get stuck.  I have a DB that uses linked
tables from a SQL 2000 Backend.  I have a query that gets the data I want.  
The SQL from that Query is below.

I have the following WHERE clause in my query
WHERE (((Nz(Year([Delivery Date]),"*"))=[For which year]))
However when the user does not enter a value at the prompt, I get no records
returned and I want all the records returned (regardless of the Delivery

Ok, I have one query that need doing for a project at uni. Problem is
this module is compulsory even though we are finance students and for
most of us programming has never been a part of our lives lol
Basically I have the following query to do:

I need to run a query and am running into a little trouble.
At this point the query includes the names of our members, the jobs they
have held, and the dates held. I need to add up the total number of years in
each job title by member.

I have a query that gives me the total Sum of Hours and Date By Month.
I need to Take The beginning Balance and subtract only the Sum of Hours for
Jan 08.  How can I do that?
example

I need to display on a monthly basis the policies sold showing the results
in a row from
their start date to the end date based on the following data:
policy_cost, date_start and date_end

Can you please tell me what would be the way to format a number on the
result table (after make table qry) as double; the resulting field is 'long
integer'; and if I want to update it with a large number is not working; I
have to change it to Double in the design mode and do the ...

I have a stored query in Access I use to export a "flattened" version of my
highly normalized database. It's exported to excel.
I have recently taught my users to use MS Query from excel, targeting the
stored "flattened" query. Unfortunately, due to the prevelance of nulls in