I inherited a db with separate sets of fields for physical address and
mailing address, all housed in tblCustomer. Even though the number of
customers with mailing addresses different from their physical addresses is
very small, the staff here have historically been doing double ...

I'm trying to make a query to fetch records from a table based on a
parameter given at run time.  It works fine if I only want to run the query
against one value, but how do I enter a parameter so it will several values.
For example if I have a simple table of:

(1) I receive an error message when trying to run a query and am forced
to shut the program down. (2) I receive an error message when trying to
export the table and am forced to shut the program down.
The database has over 6,000 records which we cannot lose. We have a

I have an MS Access database linked to a SQL table.  I'm creating a query in
Access that returns a column of type "ntext" with length "16".  I'm not sure
what that data type means but it looks to me like a Memo field.  The field
name is "ContactInfo".   In that field there is ...

I create to make a table from the query.  I have the column called "Code".
I open the table and notice that it has:
453
567

I have a table called Customers and currently use the following SQL
statement to search for a company within the table:
PARAMETERS [Company] Text( 50 );
SELECT *

Regarding the following query, how can I show ClaimCount
for each month.
A Row for each month. But over a two year period, there would be 24 rows
returned, not a steady 12.

I would like to be able to show the total number of completed tasks on my
splash screen.  I have a query which selects all my completed tasks using a
number 3 as Completed, How do I count the number of records/rows the query
produces and show it on my splash screen.

I am trying to display only the events between certain dates. I currently
have the criteria field set up with "Between Dateserial (2005, [Enter start
date (mm)], 1) And Dateserial (2005, [Enter end date (mm)], 31)."
In theory this should work, but if the month only has 30 days and ...

I have data that has all capital letters in the address.
I created an update query for the lastname, firstname, city. Works great.
How do you start where the first letter begins like in an address.
34778 MAIN STREET

How do I select records using a yes/no (boolean) field ? Say, all records
checked ?

I have a simple form with field [EmployeeName] and then about a dozen
checkboxes for questions (e.g. "Driver's License on file?"; "Social Security
Card on file?"; "I-9 on file?" etc.). With the exception of my EmployeeName
field, the rest of the fields in the underlying table are ...

I use Access IDE for work directly. I want to find out two things. In the
result pane, I want to increase the height of the column header. In addition,
I want to have more than one line.  Please advise. Thanks.
Peter

Is there any way in Access to create a row checksum, in the same manner
as on SQL Server (checksum() function) ?
I need to compare rows between two databases, which have some fields as
BinaryLong.

I am using Office Access 2003.  I am having a problem when the final Query C
below displays no data when one of the subqueries have no results.  Issue:  I
have 143 individuals that completed a survey in the database.  For Question 4
of the survey, an individual can choose either: ...