I have a table with a field (I have tried making it currency and number with
a fixed decimal of 2) that may contain values like 1.1 or 22.222 or
3333.3333.  I need to put it in a text field that is 8 characters long with a
format "xxxxx.xx".  The internal storage retains the ...

I am combining 8 text fields into one memo field using a query. After each
field I want a line feed so that each text field will be on a separate line
in the memo, but I don't know the syntax. Any help will be appreciated.
the query line looks like:

I have a field in my query which people enter the amount of time that an
agent is on the phone.  However the time that is entered for example is 6.97
or 5.68 What  I would like to do is convert this to actual minutes.  So if
someone is on the ph for 6.25 I would like it to ...

I have a query: simple extract below.
---------------------------------------------------------------
select
fieldA

I have several memo fields in my query with multiple tables.  The strange
thing is those memo fields’ character changes to different characters time to
time and I have no clue why it does or what triggers them to change.  If I do
recreate whole query it corrects itself but it ...

I have the following private sub  to process the data. It cones the data
from a subform and process the record row by row for each of the case like
"Move", "Sales", "Purchase" etc. It is SLOW especially if there are over
1000's records to process. I can use "insert" query to ...

I currently have a query which selects the top 10 numbers from a table (using
the RND function), I would like this to be changed so the user can set the
number of rows returned by entering a number between 1 and 10 into a text box
on a form and then pressing a button which runs ...

I made this DB ages ago, and everything worked fine. Ran it yesterday
to show the main manager here at work, and all hell broke loose. My
query now does not work, even though it was tested thoroughly when it
was made. Here's the SQL:

While creating query in Design mode, there is painful procedure of  inserting
fields names by clicking on the Show Table pane, selecting the table & then
choosing the field , so on & so forth.
The procedure is really killing, when we have 15 to 20 fields to update or

I have the following query:
SELECT ProjectTime.ProjectTimeProjectTaskID,
Sum(ProjectTime.ProjectTimeActualHours) AS SumOfProjectTimeActualHours
FROM ProjectTime

I am trying to write a query to take the following table:
Part Description
1001 BHJ, UI
1002 GU, SI, PQ

I have a string that's like "0101A" and "515A". When these strings are
ordered (in the Order By clause) the "0101A" comes before the "515A". In
other words it's being ordered alphabetically. I need it to be ordered
NUMERICALLY! 515 comes before 1010. How can I do this in a VB6 ...

I have several tables.  One is a list of Physicians, the others are detailing
things like their offices, specialties, etc.  The Physician table is in a
one-to-many relationship with each of the supporting tables.  A given
physician may or may not have data in the supporting ...

I created a report from a single query, and then I added two charts to the
report (from the same query as the report). I would have to enter a unique ID
number to get a report with just one person’s data on it (as opposed to every
person in the entire database). However, since I ...