I have a field that I am trying to filter any record that Has an upper case
letter at the end of the record [A-Z]. I used like "*[A-Z]" however, I am
getting upper and lower case as well. I am only interested in Upper case. any
idea?

i have a query consisting of the following fields: description, date and
amount. i have created two more fields-expressions. i.e. Expr1=Month([date])
and Expr2=Year([date]).
i have a main form which consists of three combos that serve as criteria

I have been trying to work on the following queries, but they give syntax
errors. So can someone please help me to sort them out;
1)
SELECT ISNULL(User.Name,'Unalloted') AS 'Loan Status'FROM Book b

I have a make table query that calculates requirement dates based on a
[StartDate]. All of the fields (80 of them) are set as Short Date in
properties. But when the table is created all of the fields are text. I would
like to avoid using the FORMAT command in the query and change ...

I have three tables:
Equipment
Instruments
System Numbers

I am receiving a error " Invalid Argument"  only when I run a Make Table
Query . But the select query is working fine.  
I also get the error when I import the table.
Please Help!

I have Begin and end date as parameters in my query.
The data in the table is crazy Some dates are 03/28/2007 10:30:27 AM and
some are 03/28/2007.
I tried the following:

In my query I need to trim after first space.
For example:
11/11/2007 10:00:00 AM
I need to show only date

i have inherited a database w/ o documentation & noone to tell me its history.
I have a query that shows 2 tables: "A" and "B"
Table A has several fields, B only 2. The tables are joined on these 2 fields.
3 fields called for the query, all from table a.

Hi, All:
I have a combo box displays four columns of information, the first
column was used in a query to filetring a table, then the third column
was used for filter another table to be displyed in a listing-box.

AccessXP on WinXP
Attempting to update a series of records from a LINKED table. The following
SQL statement results from the design view settings to replace classnumber
field in the datainport table with the ClassID filed contents in teh linked

Hi, I'm trying to create a field based on many different conditions in Make
Table Query in Access 2003, e.g., if VAR1 and VAR2 meet certain condition,
assign a value "A" to the new field "Category"; if VAR1 and VAR2 meet other
condition, assign a value "B" to "Category" so on and ...

How do I transpose the result from a Select Query?
I have 10 fields in a table and when I query them they give me back 10
fields!! I want to turn the fields into rows! Can this be done? I can give
specifics if this will help! I cant work this one out at all!

I'm simply trying to use a listbox to select a date and then punch a button
to run a querie based on the selected date.
The format of the link in the querie to the listbox is
[forms]![Main Menu]![list_box_mnth_sel]![Mnth of Dump]

I have a field Trans date with different formats, some are DD/MM/YYYY and
some are DD/MM/YYYY/HH/MM/SS. I want to use the Between begin date and End
date. How do I convert all the date to the format DD/MM/YYYY/HH/MM/SS
Please help.