What is the best way to design a client table with
multiple reps and addresses?

I have a parameter query which in put name of a customer then it will display all information about this customer. However, this must be full name and usually user type it wrong.
Name field: Last name then a comma and then first name.
I want to truncate the last name only from ...

I have never used Access before & I have purchased a
program called "ezebase" that will help me with my buying
& selling on eBay.
I can go into Access & it doesn't ask for a password but

Hi,
I've got form (F)+ subform (S1) + sub subform (S2) situation.
When I try to delete record from S1 it properly reports that it can't be
done because referential integrity between S1 and S2. When I delete all corensponding

I have about 250 names-and-numbers in an Excel worksheet, representing
the current directory in my *very* old Nokia phone.
(There is no direct way to move them into my much newer Nokia 6360, so
several hours of thumb-typing lie ahead.)

Access 2000 on Win2000Pro
Check it out ...run this query:
SELECT
DatePart("yyyy",#1/1/2004#,1,2) & "wk" &

I havd a button that I want to add the information to a subform datasheet. I tried using the wizard, but the table is different for this particular tab. Any suggestions or ideas?
thanks!
Wes

=Avg([total])
The name of my field is "Total".  Above is copied an
pasted from the control cource under the data tab in
properties of my text box.  It gives me "error#"

Is is possible to merge some 100 small tables into one
table, without having to create one make table query, and
then appending all the others in an append query.
The tables al be gin with the same word OUTFUT then a

OK, the criteria is a specific route (bus business) which
will be listed for a set of dates.  So I have 33 lines of
information (one for each date).  I have a total in my
last field, but I need an average of all of those totals

I have a *.bmp image file that I use as an icon on my switchboard form.
Currently I have the *.bmp file stored separately from the *.mdf file and
the switchboard form references the image by its path name.
Is it possible to store this *.bmp file in the *.mdb file? If so, how can I

Hi, we have this Access database which keep records of all our lab mice. usually there are more than one mouse in a cage. So the cage number has to be showed up in the database more than once. That makes counting total cage number so difficult when you get tons mice in your ...

I was wondering if any of you could give me some hints and or guide me to
the right direction regarding the design of my database.
It's a relatively descent-sized project (for *my* programming standards...)
both on the size of the data and on the complexity of the queries.

I need to export data from a membership database in CSV format for the
secretary of the organisation.
Currently my ACCESS database exports an XLS file and I convert it to
CSV in EXCEL.

I have a database of swimmers and times by stroke and by meet.  I have written a query to retrieve the times since a certain date.  I want to write an equation to get the lowest time by stroke and by swimmer.  How would I do that?  Thanks for the help in advance.
The fields are