Did not think this would be so difficult.
I just want to add a SUBSTR to capture the first 5 digits of a field.
AM I close???
SELECT

Does Access have a Text-To-Columns function like Excel?
I have a field in access that contains AAA-BBBB-CCC-DDDD or
AAAA-BBB-CCCC-DDD.  I need to be able to split this data into 4 new fields
like Text-To-Columns in Excel.   Please advise.    THANKS!

The query I try to make is really difficult for me. I try to don't
make it with a personnal function but I'm not sure that is possible.
I have a Table with the following data (nb: format date dd/mm/yyyy)
Contract Number    Start              End

I'm fairly new to Access and could use some guidance. I need to build a bulk
upload feed of my product catalog for Google Base. On the import to Google I
receive errors because the product description and titles for some products
contain special characters like trademark, ...

Hi,  
I am trying to create a query of mainly names and dates.  I want it to show
me any duplicate names that may have been entered on the same date.  I want
duplicates to be allowed, and I don't want them hidden or anything.  Would be

i am trying to list the values that my original data does not provide. E.g I
have a range beginning with "ABC0001" and ends at "ABC0043". How do I write a
query or to list the values not shown i.e "ABC0002" all the way to "ABC0042"
as individual values in a seperate table?

I'm somewhat of a newbie....so bear with me.
What I've got is a table that has contains various companies, products,
pricing, and what I'd call a time stamp date.....basically as a price for a
product changes....it is input in the table and the current date is input.  

I have a database of support tickets, that contain a couple of fields, Group
and YYYY-MM.  I have created a table called tblSession, which I use a form to
update this "single row" table, to basically try to create a Session Filter
for all subsequent queries.  

I have two tables, one master Info and one with multiple records for
each record in the master link by ID field.  I have a field call Due
Date in the secondary table.  I am trying to create a query that
returns only the last due date for each ID.

Access 2002, SP3
Initially posted this in the wrong newsgroup.  I'm hoping someone can help
me out with regards to being able to group and aggregate data within the
query side without having to use a crosstab.  Apparently, JET SQL uses a

I have two tables of employee records that I imported in from Excel with
about 1,500 records in each.  I wrote a query to extract those records where
the start date did not agree between then tables and the query only returned
2 lines of data, when I know that there must be more ...

After some kind help from 'mscertified' yesterday, I need some help in the
following in VBA:
Insert into Pend_Link_Table (LinkID, Route_ID) Values (LinkID, Route)
LinkID is numeric and Route is a string, with corresponding data types in

Hey Guyz,
I want to create a query that takes all results in one column
(FirstManager)and "pastes" (for lack of a better word) them into another
column (Group) but next to each other seperated by semi-colans.

I have a table that lists name, address,city, state, zip,  phone, date of
birth, etc.  
I want to send a mailing to the oldest person at each address.  
I have tried numerous group bys etc and am not sure it is working properly.  

I am trying to Count the number of work days between two dates in a query i
tryed using dhCountWorkdaysA([Date_Open],Date()) that i got form this board
but i get a err Undefined Function 'dhCountWorkdays' in expression.
C an anyone help me with this?