I have two tables.  
- One lists values for a period (tblAllocation).  The two relevant fields
are PeriodName and Allocation. e.g. PeriodName P1, Allocation 10%, PeriodName
P10, Allocation 5%

Thanks for the replies... I am re-posting.
The table has many fields, but the only one that is necessary for this
solution is called TECHNAMES.
The field is built from a form where a user selects multiple last names of

This is a re-post of my original for which I have hit a wall
I need to pick up the last time the equipment was in using the dateout field
from the job table - for instance if equipment came in 3 times Jan/Feb/March,
I need the query only want the March entry

Is there a way to use an Access crosstab query like an Excel pivot table?  
That is, is it possible to click on a single crosstab intersection, and see
the raw data behind the query?  I'm using Windows XP, and Access 2003.

i have a lot of records with data as follows:
+44(0193)5555685
i need to get rid of the +44 plus the two brackets - is there an easy way to
do this please

Hi gang,
I have a client who wants us to update a Last Name field to proper case for
any last name beginning with Mc. They want the 3rd character uppercased in
all such names. So any Mca . . ., Mcb . . . ., Mcc . . ., becomes McA . . .,

I need to have a query that counts the records grouped by Emp ID, like
12345       1
12345       2
12345       3

I am using the following SQL Statement in my Access Query.
SELECT [PrincipalPayments].[AccountNumber ], [PrincipalPayments].
[PmtPostDate], [PrincipalPayments].[PrincPmtAmt], [Account].
[FirstPmtDefault]

I have a string of objects with numbers that I must "Count"
IE.  101, 102, 103, 104, 105  There are 5 objects in this string.  The
numbers are different for each string and can vary from 0001 to 9999.
I want to count the number of objects that I have.  I do not store all the

I have a query that will be made into a form.  The query has all the records
selected and inputted by users except for the location field.  Oly one user
will be inputting and assigning the location field.  When she opens the query
all the records are there and for all previous ...

I need to replace strings that have " marks in them and It keeps giving me an
error. I need to delete html tags like
<a href="testing home page.html">
so i've been using a replace function that looks something like this

Client is running a select query based on 2 queries. If she enters a specific
report number as criteria, the query will return that record. However, she
wants the query to return all the records - then she gets the error: invalid
operation.

I have been using Access for a few years and successfully using the wild card
"*" with my searches in a query.  For the past week or so, the wild card
query doesn't return results on searches.  
For example, in a Last Name query, I'd type in the query box Smit* and all

I am trying to select cmr from Customer table and pass this variable [Cust]
to a query.
When I open the form to select the customer it gets copied into the
variable. So far no problem.

I have a function that works whenever anyone puts more than one word in a box
but now the staff are getting used to filling in a box correctly the function
gives debugs:
Public Function FirstWord(InputString As String) As String