How can I use the format function in a query to filter records for a weekly
report. Similar to the Month and Year format in  the report wizard.

want to group more than one campaign results together.
I have 3 queries for each campaign to get the results then the 4th queries
format some of the fields
What I want like to do is enter the data ones not more then ones if I update

When running a query that picks values fromm multiple tables, the query fails
if one table do not have a record that matches the selectrion criteria.
I.e. I run a query to make an order acknowledgment for a customer. The
customer can order both a service and/or and item.

I have a FirstName and a LastName field that I am trying to join in a query
under a column named Owner. The method that I am trying is as follows:
Owner: [FirstName] & " " & [LastName]
When I run the query it gives me a parameter value box instead of listing

Can anyone help me with this problem? I need to append a flat table t
two tables. I have two tables Observations and ObservationsB that ar
set up to one-to-many relationship, and one FlatTable that has al
the data that I need to append to tables Observations an

i have a table that includes records for multiple deals (i.e., 100 records
for deal ABC, 125 records for deal XYZ).  from that master table, i would
like to create separate tables for each deal.  creating a query with the
general criteria "[Enter Deal Name]" is simple in order to ...

I don't have a ton of Access use experience but:
Job Titles is a column in the database.
In Queries, the user can type in a word and it will find the job title and
corresponding ID number but it will only find it from the beginning of the

In Access XP, I'm trying to use the values of several calculated fields to
create additional calculated fields, all within one query.
Is there a way to do this?  Access currently doesn't recognize the names of
the calculated fields created earlier in the query.

I am trying to apply a label field to a query record based upon where it
falls in a second lookup table.   The look up table has a start date and an
end date and a description (Tiger, Dog, Monkey etc)
The lookup is using a birthdate from an record of a person.

Simple: I want to write a query to import data from a flat file(comma
delimited) into a exisiting table in access
using Access 2003? I don't want to use import wizard!
thanks for your help

Thank you for your readings.
I have Quary1 and Quary2.
Quary1 has text1 and Quary2 has text2 as fields.
tex1 is same as text2 except it's orientation in a field.

This is a complex query that shows debt agings for all our customers from
CURRENT, 1-30, 31-60, 61-90, 91-181, 181-360, 360+ days. I have 2 tables
joined, ARDetail and Custusage these have specific fields from the text
files. I used IIF to do the calculations for each of these ...

I have query that is the source for a sub-report.  The main report using
grouping (person, client).  The query uses the client ID that appears in the
client group header as a parameter.
When I open the report and show page for Client #1 in the preview window,

I have created a form from which to create tailored reports via several
unbound input fields. There is an underlying query to form these reports.
What I am trying to do is create criteria expressions that will take the
value entered and use that as a criteria and if no value is ...

I have a query that uses IIf statements to calculate a point system from
current horse shows based on place and number of entries.
This is the query:
SELECT Entries.Place, IIf([Entries]>1,([Entries]-[Place])*0.5,0) AS Points1,