I have a simple database with contact information last name, address, phone
number. There are three tables and I would like to check to see what info is
missing from one table to the next. I have done an unmatched query, table 1
to table 2 and table 1 to table 3. I would like a ...

I have a simple query which asks for a Result to search for.  I would like
the dafult query value to be "Message" so I can hit enter without typing in
Message.  How would I do this?

Want to join three tables as described in the MSAccess-Help, but I get an
Syntax-Error.
SELECT lastminute.last_id, lastminute.last_hotel_ID,
lastminute.last_stadt_id, lastminute.last_region_id FROM lastminute INNER

I need to return a value for a whole or a part of a month. This is to be used
for an invoicing system.
Example: A subscription is priced on a monthly basis. A subscription that is
active for a whole month should be invoiced for the value '"1" multiplied

I have a very simple database with two tables.  Each table contains similar
data.  I have created an update query to match data that is exactly the same
in each table. The problem I have is when table1 contains a record twice and
table 2 only contains it once.  The data is okay, ...

I'm learning from Access 2000 for dummies and need to have this repor
done today. I need some guidance. I have two tables:
_Customers_
name

I need to use a recordset based on a union query that includes 3 parameters.
The calling instructions are:
   Dim Base01 As DAO.Database
   Dim ReqPCTUnion As Recordset

Is there any way to show a calendar in the "between date" in a query or a
report?

I am running Access Queries against SQL Server linked table.  I am having a
problem with boolean fields where they don't recognize 0 in some fields but
do in others, so if I want to test a field for zero (false) I need to say:
[field] = 0 or [field] is Null

I need to calculate the daily discounts given by salesmen on the products
they sell.  I have an order details table with item #, quantity sold, price
per unit(actual price charged by salesman),total and date.
I have an inventory table with prices in  5 columns p1,p2,p3,p4 and p5.  ...

Hello,
Is there any way to set the default recordset type for queries so that
whenever a user creates a query in Access 2000, it will default to Snapshot
instead of Dynaset? And can this setting be done at the database level, so

I am using Access 2003 (11.5614.5606)  on Win2000.
I have set the registry, using Getz-s file for ShowPlanOn.reg
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\JET\4.0\Engines\Debug]
"JETSHOWPLAN"="ON"

I have an unbound form that supplies the information to a query that runs
when I click OK on the form.  At the same time, a report opens and gets its
data from the results of the open query.  Is there a way that I can hide that
query so that the only thing displayed is the report ...

I am trying to create a query to group pathnames when all I have in my
source table is a fully qualified filename.
ie I have a record that looks like:
\\Slug\media\Audio\Music\MP3-LameEnc\Amici Forever\The Opera Band\07

This should be so simple - I'm working on a contract database that either has
a contract number or a PO number - if the contract number field is empy, I
want to hide the text box and associated label, and show the PO number text
box and assoc. label - here is my code: