I have a query that pulls a date from a table, which is stored as a short
date, i.e. 7/2/2005. I need to convert this date to a text string so that I
may import the query record into an Oracle database as MMDDYY. Any
suggestions will be helpful and appreciated.

One of my fields begins with a blank space which I suspect is messing up my
data.  Can I run an update query to get rid of this space which is always at
the left side of my data as is _12345 where the "_" is a space.
Thanks,

I'm having an issue using text box values as criteria arguments for an access
query.  Example:
Select * from table1 where textfield1 = [Forms]![Form1]![Text0]
If [Forms]![Form1]![Text0] is less or equal 127 characters, the query works

I have a very long SELECT statement in my application (7 pages when
pretty-printed). I would like to enter comments in SELECT statement to
make it easier (actually to make it possible) to understand and debug,
but I did not find the syntax for comments in Access 2003 help.

How can i link the criteria in a pass-through query to a form?
This query works fine if i replace A and B with the proper dates.
SELECT currency, fdate, rate
FROM tRates

I am running a bunch of queries so I can make my reports. This one
query I am trying to run is a bit difficult for me to figure out.
I have 3 tables:
Request

When my users log into my database a query automatically runs and creates a
new record in a table called tblUsageStats.  Each record contains the user's
Username and the Current date & time (Now()).
I want to create a query now that will pull from that table only the last

I am looking for a simple method to find the number of workdays between two
dates, excluding weekends and holidays.  Thanks

I have a Table that contains 10 diagnosis fields, each containing up to 10
diagnosis codes for each patient in the table.  I need to pull out only those
patients that contain a V code (meaning they start with a V) in any of the 10
diagnosis fields.  I have tried doing a v* for ...

My data :
Field name : Progress
15-Dec-03 18:18 Angela Bennet:  Start packing all the old stuff.....
15-Jan--04 18:18 Shila Williamson:  Start packing all the new

I am making invoices for a gym database. IN the query for the invoices there
are 2 tables 1) clients
        2) membership
I want all the people who in the clients table are "monthly" members i.e pay

Hello, I have a table Products, and a subtable Components, which includes
several components of each product. I would like to compare the entries in
the Products tabel to find products that have identical sets of components.
How to do that ? Thanks.

I have 2 tables: A with Key1, String1, B with Key1, Val1 (sorted by Key1 and
Val1).
Table B has multiple records for each Key1.
Update query:

My Name is Dale and I am from Puerto Rico.  I am assisting my programmers (from India) gathering information how to do the following.  The goal of this project is to make it as user friendly as possible.  Merging is not so easy for computer illiterate users, so I want to automate ...

Am trying to get a sql connection to an existing .mdb file using the
upsizing wizard.
Every thing goes well until asked for the name of the SQL server.
No matter what I put in it fails to make a connection tho' I have SQL