Hi,
I have a table whose fields are:
1. date of birth ('dob') and
2. Area (ie geograhical)

I have a query that sometimes is blank (as in, no records, depending on my
criteria)
Is there anyway to have all the values be 0 instead of there being no values
at all?

I'll admit I'm completely Access ignorant. I'm taking a class next month.
However lucky me gets to support it and I have a client that asked the
following.
She would like to do a cross tabulation of an entire database. She doesn't

I am designing a query in MS Access and need to create a quarterly report.  
When I use the expression Between '01/01/2005' AND '04/01/2005' I get all the
records!  Syntax is correct as per ANSI-92??

I have a dcount function which counts the number of places booked on a
course. The code is as follows
=DCount("[status]","bookings","[event ID]=" & [Forms]![bookingsfrm]![event
ID] & "AND [status] IN ('booked')")

How long can be SQL-Query (how meny characters maximally)?
Is it same for all sorts of queries. For instance db.Execute??
Thanks
Mario

SELECT * FROM Choices WHERE Active;
The above query returns all the rows that are active in the Choices table.
The layout for the Choices table is:
ChoicesKey: Autonumber

I have a report that takes a filter condition from a combo box on a form. The
combo box is populated from a table using a UNION query that adds an ‘All’
option. The first column is bound to the control and is hidden.
Note:(Alike and % are used in place of Like & * as the database ...

I have two forms and tables say [Invoice Header] and [Invoice Lines].
The tables are joined by [Invoice Number]. I must say for some reason (long
story), the invoice header and lines are fed separately but do tie with each
other.

I have a calculated variable R. I want to build an expression in a query such
that another variable Rag = R unless R<7 in which case Rag=7. In other words,
If R<7 then Rag=7 else Rag=R. Is this possible ... I can't figure out how to
do it... thanks.

I have the following two SQL statements...
SELECT Task.Task_Name, SUM(Logged_Time.Time_Spent)
FROM (Logged_Time INNER JOIN Task ON Task.Task_ID =
Logged_Time.Task_ID)

I'm having a problem with a query.
I have many many tables that I receive from my customers. I'm doing some
queries, and these queries use DISTINCT.
However some of this tables sometimes can be without registers, they have no

I used the Find Unmatched Query Wizard to create a query. Now I'm trying to
understand what it did.
There are two tables in the table window with a 1 to many relationship. On
the many end of the relationship line there is a small arrow. I have never

In Access 2003, if I export a report to .snp (Snapshot) format, then if I
select export on another report, the Snapshot is not the already selected
format -- I have to reselect it from the dropdown every time. This is not the
behavior in Access 2000 -- the previously selected ...

I have a query that displays record info for a specific job number that the
user enters using criteria [Please enter job number].  The query works when I
run it.  When I try to use a form with the query as the source, it doesn't
ask for the job number.  I have done this before ...