Hi guys, bit of a complicated one here and I'll try my best to explain the
problem.
I have 4 tables.
Orders

Hi,
not sure if this is a join type problem or a design issue.
we have a master table listing of objects, object # as a primary key.  
Objects of different categories have different descriptive qualities, so

I have about 12000 records that need to be changed from the format:
830 to 8-3
2710 to 27-1
Is there a command I could use to do that?

I am trying to create a query that returns students that have not attended
mandatory classes. I have a table with classes and a checkbox for the ones
that are mandatory. I have a students table. Then I have a training table to
record what classes the students took. So how would I ...

I am trying to run this append query and it is not working....anyone see
anything wrong?
INSERT INTO [Audit Table] ( OM, CSM, TB, UID, Start_Date, Login, Logout,
[Sch Start], [Sch Stop], [TCS Code], [HR Code] )

I have a query that uses dates entered on a form frmMemDateReport in the
boxes txtBeginDate and txtEndDate.  The unbound txt boxes have a short date
input mask and short date format.  
Here's the query language I'm trying to use (in design view):

Satellite Collars (Named PTT on the table) on Caribou acquire a position
"fix" everyday at a certain time. It records the Postion with a Latitude
(Lat) and Longitude (Lon) as well as the day and time it acquired the
position (FixDay and

Is there a function that would test a value to see if it is numeric or text?
These values are in a text field.
Examples:
123456 = Numeric

I have searched many threads to try and find an answer.  I have a field that
has
many alpanumeric values in it.
Like SO12345 or PO54321  

Please help me solve..
Table A
Product ID = many side
Table B

I have a 20 character filed that I would like to sort by the last character,
can this be done? Also, can a drop down box pull up information based on the
last character but keep the data in the order it was entered?
THanks

I have a currency field (must stay as cacluations are performed) but I need a
query to export the file to another system so it must be a text file and must
have leading zeros. Example: I have a curenncy field $156.10 should after
query look like 0015610  (7 digit field).  I have ...

Hello, I was wondering if theres an easy way to do this.  I have a form based
on a query that I display the data in datasheet view. I would like to apply
some shading /color changes to a couple of the displayed columns. However
when I try to format the form in datasheet view it ...

Can you suggest the best way to combine two tables in a query? Here's
the situation....
I have two tables that hold membership information about two separate
groups. About 50 members cross over, being part of both groups. The

I have a query with date worked, log in time, log out time, acthrs and
overtime.  With the help of Steve Schapel I was able to convert these to
actual hours worked.  Now I need to take the actual hours worked and if more
than 8 hrs put the diff in the overtime field and if the ...