I want to have a query that shows the difference in hours from the
beginning of the month to the end of the month.  This shows the months
production output.  I will then build a crosstab query on this to show
month on month production output to see if we are gaining or losing

I can't figure out how to update my table.  I've tried using the following
script but looks like I'm trying to do something wrong.  I get the error
"Operation must use an updateable query":
UPDATE [0106 treat srcedat gwsw 5] LEFT JOIN Main ON [0106 treat srcedat

I have 2 tables (tb_A & tb_B) - (dummy Scenario
------------------------------------------------------------------------------------
tb_A: Has two columns
(Serial_no = running number, P_Name = all blank)

Could one of you please help me?
I have a report which has a parameter query behind it - [enter locker number].
I would however like to have the report to show all lockers plus info if the
user does not enter a number in the parameter box.  Is this possible?

So, I can't figure this one out...
I have small boxes and large boxes. Each day both small boxes and large
boxes might be sold. Once 46 boxes are sold, I want to know the additional
small and large boxes sold. Here is an example:

I have a problem on the soting by week, when i convert date to week ( "ww
YY") and sort as ascending the results is not i want see as below.
   Week : 1 08,10 08,11 08,...,2 08,20 08,21 08,....  ( after sorting)
but I need to show as

I am using Access 2007 in Access 2002 - 2003 file format.  When I run an
append query from a table with 129 records, to a table with 0 records. I get
the following message:
Microsoft Office Access set 0 field(s) to Null due to a type conversion

I'm trying to find models 250, 350, 550 and 750 by using "And" criteria.  It
seems to only work with two of the four.  
Any help would be appreciate.
JW

How can i delete all ole objects from my database
I tried
update <table> set <field> = null
but it does not work

I am usin Access 2003 Pro and trying to create a rather complex union query
but don't seem to implement conditions.
Let's say I have two tables called A and B. A has column called x and B also
has a column called x. I am trying to join these two columns into one column

I am trying to update my clients labour & materials rates from april 1,
using the client & materials tables.
The update works fine in the query, but when I go into my invoice form the
new rates have updated all the previous invoices that have been created. How

I am trying to find a work-around for the read-only problem when a query has
a Group By clause in it. I am working in Access 2007. Here is a summary of
what I am doing:
I receive orders from my clients that contain personal data about people.

I have a table called Tbl_Jewellery with the fields lng_JewelleryID and
str_Metal. Some jewellery can be made out of more than one metal so it is not
uncommon for a number of records to have the same lng_JewelleryID, each with
a different str_Metal.

MASTER Table:
ClaimsPrimaryKey
DETAIL Table:
AutoNumberPrimaryKey    Date    ClaimsPrimaryKey    ClaimsStatus

When I build a simple expression in a querry based on two other fields, both
numeric, the result is a text/Date value.  e.g., Expr1: [Value]+[Commission]
When I try to Format the field in Properties no formats are available and
the Input Mask is for Text?date.