This is a simplified example of what is probably a simple SQL query,
but my SQL skills are too weak...
Customer table:
   CustomerID

I have 4 tables that I'm querying, and have the basic data that I need, I
just can't figure out how to 'fine tune' to get the exact info into a report.
I have:
Dept        Emp#          Event           Date

I'm trying to execute a batch of T-SQL statements in an Access pass-through query. In short, the batch creates and populates a
temporary table and ends with a select * ... on the temporary table. It works fine in SQL Server's query analyzer, but returns no
records when I run it as ...

I want to be able to put in a date range for my querie.  Is that possible.
Thanks
David

I have a simple Access 2003 subform, as a datasheet view, I simply want to
display some of the details within the same cell but with line breaks (shift
Enter).
Each detail has numerous details but there are several address fields that

I have been trying to calculate a running sum for consecutive dates.  My SQL
for the query is as follows:
SELECT qrySKEmergenceStats.DATE_SAMPLED, qrySKEmergenceStats.SumOfSKPERHR,
(DSum("[qrySKEmergenceStats].[SumOfSKPERHR]","qrySKEmergenceStats","[date_sampled] <= " & ...

Help! I posted this two days ago and unfortunately received no response. I
did modify it slightly based on my expected lookup results - sorry if that
caused any confusion. I would like to know if what I am seeking is even
possible within Access. If it's not, please let me know.

I have an existing notes field that I want to add more information to it but
when I use the update query it erases the information that is already in
there and puts in the new. Is there anything that I could do differently? Is
this possible?

I have a query shown below:
Date        OpenedItems
Feb '05        45
March '05    21

Is there a way to have the captions of the field properties of a query to be
blank? I am using access 97.
Thanks, Tom

I am opening a subform which basically writes to the same table as the form.
What I want is I have a field in the form called DtRecd and one in subform
called DtRej. If the DtRej is a date later than DtRecd then I want to append
a new record row to the Table and if its same date ...

I have several thousand SKU's that change up to a new SKU.
Example Sku 12345 changes up to SKU 98765. My problem, is that I have an
on-hand quantity of SKU 12345 but all pricing got cahnge when I ipmorted a
new price list into the table from the supplier. Since they don t use SKU

I have a field in a SQL Sever table of data type datetime.  I enter a time in
this field by keying 8AM and tabing to the next field.  When I try to query
the table with the criteria of #8:00:00 AM# it returns no records.  What is
the correct way to query times?  Including SQL for ...

I have a table that contains just 4 fields and an ID - autonumber.
tblHIST
itemno        actdate        actqty      actcost    id
123            1020501           2          1.00       1

I've been learning Access andhave been pretty successful with it for the last
two months, using a lot of its capabilities.
Now I need to do something and I can't figure out how to do it.  I have a
database of community residents and each resident has a primary Key ID.