I don't know how to ask this question other than giving an example.
I have data that looks like this
Warehouse    Item     Company     Qty
Atlanta           xyz       Widget          5

Hi, I have a Date/Time column that is not a mandatory field. But when I do
INSERT INTO (...) SELECT ..., the query fails with "You tried to assign the
Null value to a variable that is not a Variant data type".
If I remove the column altogether from both the INSERT and SELECT, then ...

I know the easiest way to update 1 record is to making a change directly in
the Form field, however I need to show this change in a report.  I have an
employee tracking database which show name,address, wage, job, department
etc...When I change their wage, dept or job I need to ...

I have two tables ... case and cashhst that I import from a db file.  the
relationship is fairdate.case to fairdate.cashhst.  Case has the columns
fairdate, case and booth and cashhst has fairdate and case (along with a few
other, these are the ones of concern).  

I am trying to run a query that only returns the results where ...
10A or 10B or 10C or 10D or 10E
are found.
If I literally type it into the query in the format

I have a table with patient visits.  Each visit may have multiple procedures.
ex j smith
1/1/07  procedure 97110
1/1/07  procedure 97140

I have the same issue with 2 reports that I have created.  They both have
sub-reports attached to them.  The problem is that each report has a blank
page in addition to the report.  How can I delete the blank page from the
report format?   Any help would be appreciated.

I have two tables, tblAcademics and tblScores.  Each has an ID column and a
date column (Student_ID in both tables, and Assessment_Date and Score_Date
for the date columns.  I want to create a query which has all of the
tblAcademics rows, whether or not there is an associated ...

I have created a select query with date range parameters.  When I run the
query I am prompted to enter start-date and end-date - but am then prompted
again.  I enter the dates again and the query functions as expected, but I
can't work out why I should be prompted twice.  Any ...

I have a query that pulls back data through a SQL connection from another
data base that I do not control where the values are shown as two decimals
like 4.47  What I need to do is display this number as .0447   How can I
change the query to carry out the decimals to 4 places?  ...

I 'm a newbie in access and still confuse with union query.
Would somebody like to provide or create a simple sample
for me so that I can see how does it work.
Thank's at all

I have a query that takes year to date data as of two weeks ago and subtracts
out from another query that has year to date date as of today in it in order
to tell me what has transpired in the last two weeks. My problem is in the
last two weeks we added a job to the system and ...

I have  a column with text. Some contain 'Yorkshire Archaeology 1:
name of the document', 'Yorkshire Archaeology 2: Different title',
'Yorkshire Archaeology 11: text', 'The Medieval Manor and Manorial
Mills.

have a series of check boxes on a form such as  check box 1 labelled bhn,
check box 2 labelled dme, check box 3 labelled amb
when any of these boxes are checked, want to store the value in  a vb
variable. for example, if the first one is checked, the value in the variable

When trying to change data in a select query (Access 2002), it will not let
me and sounds a beep.  I was able to change data in it previously, but not
now.  In Options, I changed it to Exclusive, and no locks.  That is how it is
now, but no updates can be done.  I am on a network ...