I have prepared a tool in Access 2003 that allows me to pull data based upon
the data between two set dates [Start Date] and [End Date] that are
established from a form.  In Access 2003 I have the criteria set as...
Between [Forms]![main_page]![Text_start_date] And

I have a date field "daterecieved" i would like to query for items over 30
days old where a completed field is null. Please assist.
Thanks

I'm running an update query on tblInv that, among other things,
extracts an important number from within a string in the text field
[JobNum] .  In it's original form, [JobNum]is as follows: From 11965
OFG       The critical number I'm extracting always starts in the 6th

Help! I have two tables, one is a "master list" and the other table has most
of the files that is in the master list. Is there anyway to extract those
files that are duplicated in both the master list and the other list while
leaving the other files remaining? If anyone could ...

I've got 2 fields in my database that represent Easting and Northings.  Due
to the way the client's db is set up, I need to append each of these values
to one of 2 fields in the destination table (UTM_Easting or Grid_Easting).  
UTM's are the full 6/7 digits while Grid coordinates ...

I am using Access 2003
A couple of years ago, I created a query to append employee files from my
active Db to a Retiree Db.  I need to do this again and want to use the same
query.  But the name of the Retiree Db has changed.  How do I change the

I am trying to do an update query on 07-09 A2 from 07-09 A. Both are date
fields on tables. The only problem is there may be 2 or 3 records that have
been changed this year and it wants to update all 90 records. I tried in the
criteria Between 1/1/2008 and 5/13/2008 but it still ...

I know this is simple to do, but can’t seem to do it correctly!!
I have a “final_status” variable field that contains values such as “active”
“complete” “patient refused” and “doctor refused.”
I want to re-code or re-group these into 4 new variables.  

I have a table with a field called FUND (Range from 1 to 10,000) and another
called Class_Type, which is Null.  Weekly, the data is deleted and replaced
with new data.  The new data is unsorted  I want to update the Class_Type
based on the fund #.  This is where it gets ...

I have a crosstab query where the dates are the column headings. What
is the best way to group them by month?
I found a Microsoft article talking about how to use the Switch
command in SQL, but I am hesitant to do this because I don't want to

I have a Timestamp field. It contains the date and time. I need a date range.
Between [enter you first date] and [enter your second date] works but this
field has a time stamp after the date. Like [Enter first date] & "*" works
but not with the between statement.

I'm working on a database that contains information about how well a
question was scored on an internal assessment. In order to make the
data work for PivotTables, I have it set up as one record per line.
*The field names are Question Name [text], Score [number], Date

I am having a problem with a query i have written and was wondering if
anybody can help tell me why.
If I do not put the end where statment (Where tiered.posi....) it works fine
but when i include a where clause the column for "claimnumber" displays

Trying run an Update query to update table values with value(s) from a joined
Query.  I've tried the usual JOIN options and the following is my latest
attempt from scanning suggested solutions:
UPDATE tblRenaultPriorities AS TRP SET TRP.Description = (select PDescript

In the design grid I have created a total line that has several group bys and
firsts. I get the data I need but the column headings now say firstof and
then the field name. Is there a way to eliminate the 'firstof' part of the
newly created field name?