I'm trying to query a database, but when I get my results, it is well over a
million records. After looking at the records, many of them are duplicated.
How can I eliminate this. The query is based off of 4 tables and the option
to only include rows where the joined fields from ...

I have a form and corresponding table that I want to duplicate to keep
records separated for each fiscal year. In the past I have done this by
exporting the table (structure only) and then creating the form from scratch,
painstakingly duplicating the formatting from last year's ...

I already made a query for my Balance Sheet which is composed of Assets and
Liabilities.
I need help on grouping certain parts for my report. I need two main groups
with my report, Assets and Liabilities. Under Assets I have sub groups the

How do I insert data or addresses into a word doc from the excel data?

I would like my dates to correspond with my payments. Is this possible ie
paid on the 27 of June than on the 3 of July?

I need to make a database of my tutors but it would contain just so much
information unique to each particular person. Thus, my tables would require
many,many colums. Can I make separate tables but which refer to the same id.
And how do I reflect this when in making forms.

 I'm trying to find the Access versions of the functions to determine
if a character in a string is A-Z or 0-9. I can't seem to locate the
functions in the help file. In a perfect world., Access would have a
function like ISTEMPLATE, which would work as follows:

Forgive me, I am very New in this.  Need some help please.  I have to import
all the filenames that are Currently in Folder C:\FMS\FMSphotos into an
access table.  Some of those are jpg files, other pdf files.
How do I do this

hi, how do i get one record per page instead of continuous records one after
the other (print preview)

I have a Main table and a Detail table.  The Main Table contacts the
Client Demographics and the Detail table contains client participation
information. (Action.Field, ActionDate.Field, Status.Field, and
Status_Date.Field.

Using Access 2000 and in the past I use the On Open property on my forms and
open up the macros and use the Maximize command and name it mcrMaximizeForm.
Is this the best way to do it?  Also, in the database I am building right
now, I have several forms I want to use this on, can ...

The following code is giving me a "Compile Error: Label not defined".
Private Sub cmbWorks_AfterUpdate()
On Error GoTo Err_cmbWorks_AfterUpdate
Dim stDocName As String

I work for a mailing company that address personalised
letters/envelopes ect but i am having a problem when
sorting a table by text fields. If i sort my table by for
instance street addresses then save the table everything

I have several fields in a d/b that are "true/false" type.  I am trying to
display the count of the true entries in these fields.  When I try to use the
count function in a query I get the total number of records in the d/b.  I've
tried to use the criterion that the variable is ...

I have a form that is use to filter records in the subform. In the main
form, they are all unbound textbox, and they are used to search records in
the subform.
This form have been done with the help of this forum.