I have the following data
Clm                  SEQ
43643251220000    998
43643251220000    999

Hello..
I've been searching for an answer to my query question in here before
posting my inquiry, and I've found a couple. However, I cant see any straight
answers to other people's questions so I'll be asking the same question and

Does anyone know how to do this? I've tried with no luck. This would be a
HUGELY useful feature.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I get a weekly csv flat file from UPS with data about shipments.  In this
file the date of shipment  is a string that is, for example, 9242005 for this
week.  The last 4 fields are always the year, the 5th and 6th from the right
are always the date and the 7th (and 8th for 2 ...

I have an Access application.  I use many tables just for sorting data.  Most
of what I call sort tables are initialized (data deleted) prior to the sort.  
Does it matter if I place the sort tables on the local drive instead of on
the network where the other data is?  I'm ...

Q: I have phone numbers in a text field with dashes (123-456-7890). I want to
remove the dashes so the phone number data looks like this (1234567890). What
update query will do this?

My phone numbers are 9999999999  I want to ENTER dashes in the correct
spots.  999-999-9999
In some cases, the data entry people made mistakes and entered 99-9999-9999
or 999-9999999

I need to query data based upon the multiple criteria selected in a list box.
Can't seem to make it happen.  I'm not a coder... please dumb it down.  
Thanks

I just  switched the record source of several queries from tables linked via
ODBC to a pass-through queries.  I did this so that the user won't et a
log-in prompt each time the access a query linked to the ODBC table.  The
pass-through queries to the same tables have the log-info ...

I have the following Dlookup in a query which does not return the correct
result.
SD1: IIf([PolType]="19",DLookUp("[SD]","[TblCharges]","[Class] = " &
[PolType] And ' "[TransType] = " &

I have the following Dlookup in a query which does not return the correct
result.
SD1: IIf([PolType]="19",DLookUp("[SD]","[TblCharges]","[Class] = " &
[PolType] And ' "[TransType] = " &

I organize different system change requests by using separate tables for each
system type and give each change request a priority number.  I have reports,
using sub-reports, showing all the priorities within each system (table).  Is
there a way to create a query or report that ...

I have 3 tables - Students, which contains all students; Attendance, which
contains dates a particular student was absent; and AttendanceCtrl which
contains Quarter beginning/ending dates. I need to be able to calculate the
number of days a student was present, absent, tardy in a ...

How do you write a query that will change UPPER CASE to Proper Case In All
Fields?
Dale

My friend handed me a mdb file for inventory tracking. Cant find the back
door to get into the tables,query etc. he showed me once but i forgot it.
some kind of pressing the Shift+Enter. It did but for few seconds only after
that the tool bar/task pane disappear..