I'm having an issue with a linked table.
Overall picture: Our internal database uses .dbf files. I am using
Access 2003 to update prices within the database using price lists
from our vendors.

Instead of having the same date 50 times on a report, how can i group it so
there is only 1 date per day, instead of 50?

I recently inherited an Access database that needs to refer to files
within the directory where the database is located.  After viewing the
code, the modules use the CurrentProject.Path method/attribute to
determine where it's located.

Is there a way to merge two fields in an Access database? ie: merge the first
and last name fields so the first and last name appear together.

MY XP MEDIA EDITION IS EXPERIENCING A FADED VIDEO PROBLEM WITH CERTAIN VIDEO
AREAS BUT NOT ALL.  THE ONES WITH PROBLEMS ARE CYBERLINK POWER DVD, REAL
PLAYER,  NBC NIGHTLY NEWS, MEDIA PLAYER WHEN USED ON IMPUT VIDEOS FROM OTHER
SOURCES BUT IS FINE IN MEDIA CENTER ITSELF.  WHEN ...

I need to have my query look at the number of times a participant has attend
an event and if less than a set number  (ie 2 times) it removes them from a
participant list yet keeps thier name in the database.
As always all help is appreciated.

I have two tables, tablea and tableb. I have a field in tablea called
test. I have a field in tableb called test2.
When I create a new record in tableb, I want it to fill in the value
from latest record from tablea test into test2.

I am creating a new dbase that will be used similar to a bill of material
(BOM).  My problem resides with making the two primary Tables to interact
correctly together.  I have created a main data entry form and a Subform that
will be used inside the main Form.  The main form will ...

I am helping a co-worker with a problem, and we are both new Access users.  
The problem is within a subform.  In the past, I was able to enter new
records into the form and they would remain in the same order in which I
typed them.  Recently, my co-worker asked for my help when ...

I have a query whose criteria are provided through a form.  The query runs
successfully.  however, I would like to clean up the results and show them to
DB users in a form as well.  Unfortuately, I have not been able to figure
this out on my own.

I am trying to get this code to work.  IT is supposed to create a
table when a button is clicked.  This code is not working.  When I
attempt it, access gives me the error "Runtime Error 3219: Invalid
Operation"  This occurs at the line that says

xin loi ma'y khong da'nh TViet duoc,mong anh chiu kho' doc
toi ten:TRAN HAN QUAN(tuoi 50),hien dang song o TP.HCM  toi bi thoa'i ho'a
do^'t so^'ng,toi da~ hup CT o benh vien Cho Ra^~y(tp.HCM)
*ket luan:  thoa'i ho'a dot song-dia dem  co^?  ta^`ng C3->C6 thoa't vi

Would you please show me how I can make a link or connection between Excel
and Access?
For example: I wanted to import or link data form Excel sheet to Access
table and as soon as I enter new records to Access table, the new records

This should be an easy one but I searched the board and was unable to find
anything that directly addressed my question. What is the best way to export
a recordset to excel? I simply want to export everything in the recordset
including the headers to excel. I need to do this in ...

Good day good people.
I have to build a query that takes the value in the last row and from that,
deduct the value in the same recordset from 13 records before. The problem is
that i can not use the record ID field to refer to in a Dlookup as the record