I have a worldwide membership database where I need to check that
members do not have duplicate entries.
I propose to check the combination of "LastName" and "ClubName".  So
the query needs to say:

I have a table being created in MS Access from a query.
The table returns all the data I want in my query based
on the criteria I set. Occasionaly one cell/field in the
table is blank, (Beacuse the original table has a blank

I have a bank account where I can collect the data as a CSV file.
For some peculiar reason the debits and credits are delivered in one
column. The debits are shown as negative values.
How do I write code to place negative values in a filed called

I would appreciate instructions on how to accomplish the following:
I would like to add two fields to a table that I have copied from another table (created a long time ago by someone else where I work).  The first field will contain the result of dividing the value in one ...

40 days in now, MS, after a 10 year layoff, ya'll been brilliant.
 Check this out, please sirs, (and/or ma'ams if there are):
    Runtime Error '2465'
 Project Mobile (3.1) can't find the field 'Controls' referred to in your

I have a Chemical table that contain all chemical. I need to search for their name offten. If there is not this chemical in the table, I will input this chemical. If the chemical already in the table, I will not to input it. However, find function in access just find the exactly ...

I have two databases (almost identical) that I'm copy data between two
of the tables.  Table1 has 350 records and Table2 has 380 records.  I'm
just trying to copy all the records from Table2 to Table1, but it only
copies the first 350 records.  What can I do to allow it to copy ...

In building a query, I use:
Not Like *mystring*
if mystring may be part of a larger string.  Access then converts the
criteria to:

I imported a database from Excel.  Have a field in a table called Bday.  It's a text field (length 5).  I recently added an input mask of aa/aa.  I've got a parameter query to pull the birthdays during a certain time period.  The birthdays that were imported without the mask ...

Hi there...
I am using a list box to display values for the user to select and the selection is supposed to be a filter in a SQL query for another list box. My problem is that I need to allow the user to select multible rows in the list box to build the query. Any one out there ...

Using Access 2000 on a 4 computer network with a
customized data base that attaches/detaches to tables
housed on one computer. Worked great with Windows 98, but
Windows XP must share files differently because it just

How do I compile an access database into a standalone program? Do I
need special software to do this? Does it cost money or is it
available as a free d/l on the net somewhere?
Thanks,

Below is a Function to calculate the number of workdays between to dates.
The code came from: http://www.mvps.org/access/, so the author gets full
credit. There is so much great info available on sites like these!
My question. How do I have the result displayed on a form? In ...

I have four tables:
tblEmployees (employeenumber, firstname, middlename, lastname, address, city, state, homephone, cellphone, hiredate, salary, terminationdate, referredby, Notes, DateCreated, UserCreated, Date Modified, User Modified)
tblVacationDays (VacationDay1, VacationNote1, ...

I am using the following expression in a query.  It works
except that I am getting a negative number.  Can anyone
explain why?
Days in Hold: IIf(IsNull([Release Date]),DateDiff("d",Now