I am trying to update a table with the item counts from a crosstab query but
I keep getting a Datatype Mismatch error.  Is this even possible or do I need
to create a function to do this instead?
The table I want to update has these columns:

Hello friends,
I have Table:DailyRecords Where CummQty is Calculated Field.
DRId  Date  ItemNo  LocationCode   QtyToday  CummQty
  1   OCT01    1              1                500           500

Im try to find out which stuents had a greater then avg grade how do i write
this?
I tryed the below no luck.
SELECT studentname

I created a query that will count the total Work Orders by Week and I have
Chart for that: y- count of WO and x- Week, Year.
In the Query I have:
WO# - Count

When I export my data from a query in csv format, one of the fields which
has 13 digit numbers diplays decimal places when infact the data in the
database does not have any decimals.
How can I force this field in my query to format with zero decimals so it

I have a "Customer" form to input customer details. The e-mail address is in
two parts: "e-name" and "Provider". I have a Provider table the field in my
table shows IDProvider"1" Provider"hotmail.com" and "2" "yahoo.es" etc. This
is related to IDCustomer in a 1 to many ...

How may I write a query so it adds a field to the information otherwise
returned which contains a sequential ID number?

Both of these Select statements return the same set of rows.  How can I find
out what's really in them?
Select * from tblAcademics where description = ""
Select * from tblAcademics where description = " "

I have a query that returns the following records:
txtRecNumber     RSum
8                       3701
7                       3030

I am trying to add a functionality into a db I use for my checkbook that will
help me plan for and save money for future large expenses. Into a table
called tblFutureTransactions I want to enter records for upcoming large
expenses, the dollar amount needed, the date the money is ...

Is there a way to find out the number of Wednesdays between two given dates?
Thank you.

How do I get a query to pull data from two different tables?

Can I join fields in a query? Example I have a Home Name, a Mothers name and
a Fathers name. Can I join these in a query to show HOME, Father & Mother on
1 line?

FosterHome: [Foster Home] & ", " & [Foster Mother] & " & " & [Foster Father]
& "               " & [FH Address] & ", " & [FH City] & ", " & [FH State] &
", " & [FH Zip] & "    " & [FH Phone]

I need to create a querry that needs to have values of two
different columns to be looked up in another table. Ex.
Table: ChangeDetails
  Column: Note