Let's say that all the fields in Table 2 are in Table 1 - but not the
reverse.  Do I have to add in fields to Table 2 in order to merge them
properly, even if I am leaving the data in them blank?  Or perhaps I can
merge them and then whichever fields Table 2 does not have (let's ...

I want to create a table to store student name, ID#, birthday, and all dates
that the student attended. If the student ID# is the primary key, how do I
do this ?Eventually in a form and a report I'd like to pull up "last date
attended" to see the most recent time the student was in ...

I would like some suggestion as how to setup a database that would allow all
users input in one record per day then the next day will be next new record.  
I am planning to create a database with a form to keep track many users who
are testing their ESD strap daily.   I like to ...

i would some help on how to send mail using microsoft office cause i dont see
a send button i dont understand it. thanx

How do I link a membership database of 200 people paying in a set amount each
month to a spreadsheet?

I've inherited a MS Access product database with item options. I'm trying to
create a price list/catalog based on the product database:
The fields in the Query are:
A. Item_Price  (The price of the item if no options are given)

I must have lost my mind because I can't figure this out:
tblShows has a one-to-many relationship with tblAgilityRec.
I have a form based on a qry that includes tblShows and various other
tables. I added a button to the form that opens a form based on a qry

Continuously, over time, the mailing labels report that I set up changes
from 2 columns by so many rows, to just one column.  Started with my Win
98 computer using an Epson Inkjet printer and continues with my Win XP
(different computer) using the HP laser printer. The only thing ...

Option Compare Database
Option Explicit
   Dim dbsBALLS As Database
   Dim rstBALLS As Recordset

I am trying to find out if I can add my own spoken words to a picture I've
scanned and stored in the My Pictures File. I have Windows XP

I've had a look at some existing questions, but being fairly new to Access,
I'm a bit lost once I get to the code stage.
I have a table someone sent to me, which i need to append to an existing one
database.  Their date is in the format DDMMYYYY, but is formated as text.  My

The following is a view of my database:
Table Relationships (which are questionably setup)
Liturgies(1) to LitEvents(many) and Cycles(1) to LitEvents(many)
Assign1() to LitEvents() and Assign2() to LitEvents()

I'm new to using Access and need help.  I would like to create a form that
my sales reps can enter their request into.  That form would include: Rep Id,
IAC, Pounds, Pt#, 1e#, Ht#.  I want to be able to go into this database and
process their request and post it back to them with ...

    Six years ago I have developed quite an large application called Elias
in MsAccess97. The company was and is still satisfied with it, so there
was no reason to convert into Msaccess 2000 or higher. However time has
not stand still. They want to access the application through ...

Hi Ed, Duane or anyone who can help me again
I studied access all weekend and realized just how similar it is to main
frame report writing.  I know how to write conditional statements, I just
could not figure out where in Access.  For example, I want to define a field