I've created a query that works the first time I run it but gives me an error
saying "Numeric field overflow" if I run it again.  The only way I can get
the query to run is by making a change to the design view in which case it
will run once.

Students: StudentID, CompanyID
Companies: CompanyID, CompanyName
ClassRegister: ClassRegisterID, StudentID, ClassID
Classes: ClassID, InstructorID, LocationID, StatusID

I have a table with a date field. In query, I would like to convert the date
field like mm/dd/yyyy to just the year and month. what function do I put to
achieve this?
PS. if the format is yy-mmm (08-APR, 08-JAN), when I export the data to

I am a novice access user who is looking at someone else's application.  
They have a Post Table and a Comments table.  There is an id field in the
Post table that links to a Post_Id field in the comments table.  When I open
the Post table, there is a blank field on the far left ...

I have a query that I am trying to count how many times a record appears in a
field.  The issue is there are some where the record is null, and it won't
count these.  Is there a way count nulls, or give the nulls a value?

I have created a query using a table and another query but cannot write into
it.  I dont get an error message at all just a bleep.  I have tried doing the
query using the 3 tables that I need but the same thing happens.  Each
query/table concerned has an ID field which is linked ...

I am trying to modify a query(qryNewReten)whose source is a single table
(TblNewReten).  The table contains a numeric field(HA)that correctly
contains repetitious numeric values. I want to use the 'values' from the
HA field to serve as the source to a combo box; but I would ...

This may not be as complex as it seems to me, but I am trying to determine
how much of a problem I may have in one of my databases.  
The core of the problem starts when my users cut & paste email responses
into the comment fields that contain CR & LFs.  It would not be a big deal ...

I am performing a count function in a query to give me total accounts
grouped by state, region, district.  Problem is some districts do not
have account #s in them and they are not on the results of the query.
I've been trying to get the results to return a zero for the null

I am new to Access, and am unsure how to run a calculation based off data in
my table using a query. I have 2 multi-column lookup fields in my table and
want to divide one by the other. I have a feeling that Access is trying to
use the data from the other column in the ...

I have linked via ODBC tables from another database.  I have created a query
to pull in two columns of information from the two tables in the query.  I
would like to add an extra column that is only created when the query is run,
to dynamically number each row incrementally, ...

I've searched here and on-line and not found any mention of this.
I'm using Access 2002.
I create Query1 that selects DISTINCT (Unique Values = Yes), returns two
fields, uses date range values in controls on a form as selection

What's the benefit of this INNER JOIN statement:
SELECT ContactsList.Name
FROM ContactsList
INNER JOIN TaskContacts

I recall that this used to easy in previous versions (Unique values
only ??), but in 2007, I can't get this to work at all.
 I have a table with our companie's job numbers in it.  The job numbers
show up multiple times because of different phases of the project:

I have a query that uses the dateDiff function to calculate the number of
weeks between dates. The problem I am having is if the dates are less than a
week apart how can I get the query to update my text field to 1.
Thanks in advance.