I have dates 20060605 and need to convert it to 05/06/2006 - can any one help

I want to compute taxes on Grosspay in a test access payroll query.
Conditions are as follows:
Grosspay is a calculated field in the query and is monthly.
It must be converted to annual-salary(salary*12) before computation based on

I am new to this discussion group. My question is how do I format date and
time in my table. I import my spreadsheet and the data is fine, but
afterwards when I go back into the table that houses the info I just imported
it converted my dates and times as numbers and decimals.

i have some records that are dates, these are say the date an order is made,
i need to calculate the next friday from that date for a delievery, so once i
have entered a date that the order has been made, i need an expression that
will calculate the delievery date being the next ...

Any idea how I could make the following query work in Access?  Any
help would be greatly appreciated.
SELECT
orders.ouser, products.cname, customers.clastname, oitems.score,

I have a table containing various records identifying items. Each item is
given a sequential number (lets call it a line number). For example, I have
10 records each having a line number field containing the values from 1 - 10.
I want to add a new record but it should logically ...

I've built a search form with abou 15 controls, and I want users to be able
to select parameter criteria freely.  If they leave a control blank, I don't
want to lose all the records in the resultant query, NOR do I want the query
to return every record.

This is my case :
First, the query should find which employees have a contract and add a
record for each employee ID
After that it should add a column which holds the value of the last date at

I want to have a criteria using the like condition on a field.  For example
the criteria Like [tbl_ALLO_HIER_FROM_COSTCENTER_FUNCTION].[allo_hier] & "*"
is under the field hier_cd.  The query works, but only to a point.   EX.  
Allo_hier has NIC and NICDM.  Hier_cd has NICDMQOL ...

I have an update query which calculates the current age for cows. It is
DateDiff("m",[Date of Birth],Now()). However i want it so when another field
called Date of Movement has a date entered i want the current age field which
is automatically updated to have 0 automatically ...

I have a crosstab query and I would like to know how to add a grand total at
the bottom for the three columns I have.
Here is my SQL code:
SELECT MotionWithBearings_YTD.[MI Loc], MotionWithBearings_YTD.[Branch ID],

I have a form where I would like the "Quarter" entered automaticly  when the
date is entered into the OTDLdaTE text box. Currently it has to be enter
manually into  "Quarter" text box. I have not worked in the property area of
the forms or text boxes and do not know if I should ...

I have an orders table with several thousand orders. Each order has a
Product_Id and a SubProduct_Id.
I want to create a query that lists each Product_Id and the number of
different SubProduct_Id's associated with it.

Please help, I am trying to use the switch function. Below is query used.
But my problem is when I use the query to display in the report it return
blank spaces if there is no value in B, C and D column. column if no A
calibre and so on.

In an Athletics program (built in Access) I have created a report (based on
a query) that shows the number, name, sex and race time of each athlete. On
that report I'm able to calculate the difference of time of each athlete to
the first racer (creating a field on the report header ...