Is there a way to take two sets of data that have a many to many relationship
and create a one to many relationship using a query?
For example:  I have1 person that has 15 Certifications that happen every 30
days and during those 30 days I have many visits coming in randomly. So I ...

i have written 2 separate queries to delete an individual record in 2
separate tables by employee name with a "like [enter name] " arguement.  the
queries work as i need them to, but i combined them into a macro,  and i need
to enter the employee name twice via dialouge box.  is ...

This is somewhat long, but please hang in there.  I wasn't sure how much
detail to include.
I am trying to use a combo box column1 on the main form to filter the
recordset of the subform.  I have about 10 comboboxes and I am finding that

I would like to know if it is possible to write a select query based upon
the number of records within a group.
I have a table with a primary key made up from 2 fields. The first field is
Billing Account Number and the second field is Invoice Date. I have several

I will do my very best to explain what I'm trying to do, but Microsoft
Access isn't my first language so be kind!
I am creating a database for a technical library. I have created a query
which is linked to a form via a macro. My users have 3 combo boxes where they

I have n access database which is split with the tables in one database and
the queries etc in another,
I have created a table called zztables and it is populated with the names of
the tables that are linked

I have a table with the following columns: StudentName,
DatePointGiven, PointValue, Comments, Archived.  I also have a table
with a single field: StudentName, that contains a listing of all the
employees.

I have a table of Potential customers which were the subject of a mailshot.
I join this table to Current Customers to show how many potential customers
responded to the mailshot by placing an order. I want to include in this
data, in each row, the total number of records in the ...

Hello all, I have run this query with other tables (basically the same) and
have not had a problem. Can anyone tell me if something looks wrong with this
query? SIT is the watchstander and I want to query all incidents when they
were on watch.

I am trying to truncate one field in a table, however the field size is
variable (the character lengths of the records are 13, 14 and 15 characters
long).  What I was wondering is how I would truncate this field in Access so
it takes just the last four characters?

I have table A, table B and table C
table A contains contact information with a long integer primary key
called contactID as the first field..
table b stores the relationship between each contact and the

    I have a table with 12 fields, 3 of which are named Keyword 1, Keyword 2 &
Keyword 3 with each field and each record containing a keyword in the
appropriate cell.  Using the query design wizard I have created a “keyword”
search whereby the user types in the keyword they are ...

there is a query joining two tables and im looking  a way to say No to those
records if some specific fields from the second table ( for example a date
field) , its value is Null or blanlk....
Thanks

I am a newbie to MS Access and I am trying to convert a spreadsheet
into an access database so perhaps I need to design things
differently.  Please forgive my stupidity since I have spent three
days on this and am certian that I'm approaching the problem from the

I have a button in a form with the following code:
te Sub CmdGo_Click()
On Error GoTo Err_CmdGo_Click
Dim stDocName As String