I'm trying to extract a range of information using a timestamp field through
a select query.  I'm using Between[Date] and [Date].  It's not caputuring all
of the records, specifically the records w/ the 1st and the very last days of
the range.  I tried doing something like this ...

I have a problem, which I'm stuck with.
If somebody has a suggestion, please help.
The situation:
I have a database for intranet logging where I import data in tblURLs from a

I have a user that created an access database. User created two tables and
then created a abend query. When she tries to run the query it just clocks
(moves about 3 bar spaces as far as completion) and eventually user gets an
error message "Not enough space on temporary disk"

I have 2 columns with duplicates in the first column and no duplicates in the
second.  I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie:   abc            1234

I have struggled my guts out studying IFF and str functions over the years
and I still have problems with certain ones. I just have not been able to get
this one to work. I have district name-projectsomething in a field. So it may
be fayeteville-electrical, batesville-roofs, ...

I would love to see some examples of wizards that people have created that
allow users to create queries of databases.  Please let me know if you are
aware of some good wizards that exist online or have templates that are
available for me to look at.

In Access 2007 I have a set of tables in which the name of the index field
has been changed.  How can I update the queries, based on these tables?
In data view I get the 'Enter Parameter Value' box. Enering the new field
name in various formats gets me no results.  Trying to get ...

I have a query set so I pull DISTINCT dates in the SQL from 1/1/08 thru
12/31/08 to take out duplicate accounts, this works great when I run the
report quarterly or yearly but  I need to run this report monthly. I have
3 tables that work together and these dates are coming from ...

I have 2 table
Stock_Table
Sales_Table
Stock_Table Contain This Field

I'm getting a key violation error whenever I try and append records from a
table in Access to a table on a MS SQL 2005 database.  The SQL db's table has
an IID field which is the primary key for the table (and the only indexed
field in the table) and I am NOT trying to append ...

I have a table with temperature readings of different locations over a period
of time.  Thus multiple records per location.
I have a query to show me the min and max temperatures for each location.
I needed to add to that query the date when the min and the max temperatures

Can someone please help me with the calculation for [c?]
I've tried to write out an SQL below, but it doesn't work because of a
circular reference. (other than the circular reference, I believe that it is
correct but I am not able to double check as I keep getting the circular

I can't seem to force a name change to a field which is summed.  It keeps
reverting back to "SumOfWhatever".  Any suggestions.  I am exporting my query
to a spreadsheet for charting and I don't want to have to change the column
headings there.

Morning All,
Is it possible to trim reoccurring symbols of values from a field.
I have combined 10 fields with '/' seporators, the 10 fields may or may not
contain values so if the first 2 fields have values the end field shows

I have a table which looks like this:
DRG    Patient    Costs
==================
A         a            10