i am working with data set up in 15 minute increments and i need an houly
average of the data.  the time is set up in military time.  i am trying to do
a group by query, but i do not know the correct way to get it to group by the
hour. i figure you nned something in the criteria, ...

I use A2K
========
The following function works fine:
HmPhNumPaste: Mid$([H-PHONE],1,3) & Mid$([H-PHONE],4,3) & Right$([H-PHONE],4)

I'm looking to write an expression that basicly says the following and I
can't work it out at all:
when "field X" is less than 100 concatanate "0" & "field X"  , when "field
X" is greater or equal then 100 just show "field X"

This is easy in a report with the cumulative total in the properties window
of the field.  I'd like to know how to do this in a query or some other
method that allows writing to a file.
Thanks,

is there a way to use an UPDATE statment to update table in an external
database?
I need to build a patch that will modify some data in a database that is
fa...far....far from me. The database is huge: no way to have it by email.

I am building a table to be used as a reference table for Excel users. In my
make-table query, I have taken fields from 3 tables- the autonumber field
from each table and a text field from each table. When I try to run the
make-table query, I get the error message that only one ...

I´ve pasted my SQL below. It is joining 3 queries.
My problem is that in the cases where I used Null for some columns, those
columns loose their heading. Is there a simple way to enter the heading here,
or should I just solve the problem by making a second query?

I have a table as following:
CustomerName         ServiceItem            DateOfService                  
ServiceStaff
AAA                          1234                      1/1/2005              

Folks, I'm probably doing something really stupid, as I've done this sort of
things loads of times and it's always worked fine before, and now I haven't
got a clue what I'm doing wrong....
I've got a bound form with several bound and unbound fields on it. I'm

2 Questions : First can a recordset based on a groupby with sum fields query
and
Second Can I use that recordset to input data in a table using a Sql insert
into string?

Hope someone can help.
I have a field in a table that has '0' as a default value that
indicates that no result has been temporarily stored.
When updated many of these values will change to the range of 95.00 to

I have a query that picks up dept name from a text box.
If dept name e.g is dept1, the querry wroks ok.
BUT if my text box says "Dept1" or "dept2", then it does not give the result
for dept 1 OR Dept2.

I have a query with a calculated field called Export.
Export looks like this:      Export: "IWTP" & "-" & [CourseID] & "-" &
[VendorID]
The CourseID is a 4-digit autonumber field with a format of 0000,  and

I want to say thanks to Allen Browne because he answered my question an
it was very useful for me.
Now I need some help again
I have one form with one cbo, it provides information to one  subform

Ok the end of the year is coming and I'm getting requests to alter my query.
Right now I have a query that selects the starting month, ending month, and
year from a form. How would I be able to select the starting month & year and
the ending month & year? This could be very ...