Is there a way to change the order of the text in a field?  For example, I
have a name field in my table that has last name,first name (ex. - Doe,John).
I need to change the order of the text in that field to read first name last
name (ex. - John Doe).

This is also on the forms- and have not gotten an answer need to know if at
all possible as soon as possible- Thanks
Thanks for your help I am still not seeming to explain what I need clearly
Right now I want to grab Today's DAY and pull up all records in the

INSERT INTO tblPhneNum(colPhoneNumbers) Values (8055551234);
Is this right?  There are only two fields in the table the id field and the
phone nmbr which is an integer.
thanks,

SELECT tblCalls.ColTime, tblCalls.colProblem,
tblCalls.colResolution from tblCalls, in dbCallLogs
WHERE tblCalls.colResolution from tblCalls,
in dbCallLogs where tblCalls.ColTime >= #12/1/2006# <= #3/2/2007#

I need help converting time to an AM/PM time format
our database displays time in 4 digits : 0006, 0737, 1217, 2149.  I am
finding that 0006 is 12:06 AM and 1217 is 12:17 PM, etc.
The date displays: 2007-03-09 00:00:00.000, how do I have it display the date

What I really want to do is update a table when another table has been
edited.
I have a table of attendence, and another for registration that the
table attendence is created from based on an Append Query.

Can I show all the data or merge them into one single cell,
instead of doing any aggregate functions such as sum and average,
in a Crosstab Query?
To illustrate my question:

I have two queries that I need to join the information from.  One query is
for employee attendance (i.e. vacation, sick) and the other query is for the
work schedule (when they were originally scheduled to work).  How do I
accomplish this?

I'm trying to combine data in fields that I currently have in multiple
fields.  Allow me to elaborate.
Lead employees are assigned a case (with a unique ID number) and may
or may not have other support employees working with them.  The DB

I made a subform with a twxt box on my main menu to show a "quote of the
day".  I have about 200 of them etnered into "table_quotes", containing
fields "[quote]" as memo, and "[quote_ID]" as number (PK).
I made a query with the following SQL, and it returns a new quote every time

I have a simple sum query to sum sales.  No need to pay attention to my
criteria expression as it is just narrowing down the selection to one record.
When I take grouping off (no sum), the sales figure is correct.  Here is the
SQL for the query:

I have two criteria in a query that are set by ComboBoxes in a form.
The query works correctly when something is selected.  Sometimes one
of the Comboboxes will not be selected and I assume the value will be
null. I've tried variations of the following expression in the

Hi.  I'm not even sure that this is possible, but here's my
situation.  I have data whose attributes may increase as follows.
Table Defects
Integer: StepId

i can't think of how to do this, mabey someone can help me.
i have a tbl employees (not our employees but employees from a company thet
we sold to)
i have the $ amount sold and the # of payments they have to do (credit) this

I need to write a query that will give me all the records in  table A that
aren't in Table B I know there is a way to do this, but i can't seem to
figure it out.
Help!