There is a text field that does not allow zero string and is not a required
field. In SQL Server inserting a null value is something like this:
Insert into table(id, txtField) values(34) -- that inserts a null value into
the txtField field.

I have a table that has the following pertinent fields:
Date, Qty
Each day a new record is added with that date and the new quantity. I
need to write a query that will show the difference in the most recent

I have a daily query that pulls a large amount of data (800k+ records) from a
badly engineered Oracle Database. The query itself is pulling data from 3
different tables and is filtering for the current year only. When I run the
query as a Select Query, the results 'pop' in about ...

I have two tables.  
The first table stores job #'s, owner name, address, etc.  The job # field
is autonumber.
The second table stores bid results for each of the job #'s.

I have a query that is based on a table containing job numbers.  When the
query runs it prompts the user for the job number.  How can I validate that
it is a valid job number from the query?

My database is as follows:
tbl_Bill_To_Address (Bill_To_Code (primary key), Bill_To_Customer)
tbl_Rep (Rep_Code (Primary key), Representative)
tbl_Territory (Territory_Code (Primary key), Territory)

In my table i have dates in this format 2/2/83. I need help on making a query
that will allow me to search values in fields given a certain date range. For
example i want a query that will give me all the values from 12/28/82 to
2/2/83.

Is it possible to build SIMPLE triggers within Access.  I found info on it
in the help pages but is all refers to ADO and SQL server....nothing about a
standard Access DB.  Can someone point me in the right direction?
Thanks

I want to use the same query for different forms and reports.  Can I create
conditional formatting on a calculated field so that it carries over to the
forms and reports?
For instance:

I have a query set to prompt the user for input, it searches 2 fields and
then pulls up the record.  I am wondering how I can get it so you can only
type part of the word and have it pull up any record containing what was
typed.

What is them maximum row output when using the Tools/Office Links/Analyze It
with MS Excel ? I know the Excel limits the row count to 65,536.  The query I
am trying to analyze with excel has only 30,319 rows.

Is there a way to populate the To: field in Outlook from the results of a
query?

I have two tables; TableA and TabelB.  There are some records in TableB that
do not exist in TableA, how do I write a query to update TableA so the
records from TableB are inserted in TableA?

In a table there is a number field that for the half of the rows doesn't
have values. When I'm running a query as IsNULL([FieldName])=True, I get
those half the records that FieldName doesn't have values. But when I run
Len([FieldName])=0, I don't get any record not even one. Can ...

Folks, I've got a query to run and I can't for the life of me work out how
to approach it... any ideas??
Here's an example of the records
     Record SAASMSN UnitSN Applique BoardMarried BoardDivorced AppMarried