I'm having problems exporting a query as a csv file. The application (Sage
accounts) i want to export it to can only import it if it has a .csv file
extension. As i can only save the query with a .txt file extension I need to
somehow convert it to a .csv file. Any suggestions ...

Hi, I have a query named "Salidas", I want a code in VB that opens that query
(docmd.openquery "Salidas") and define a criteria in the column "Tipo" (that
can be "facturas", "Notas" or "Sal. Int.").
Example:

I have three tables.  One is called TherapistMain and has two fields:
TherapistName WeeklyTargetRevenue.  I then have a WeeklyProductRevenue and a
WeeklyServiceRevenueTable. Both of these tables have the two fields which
include TherapistName and Revenue.  There are frequent ...

To query a field that has a value list in order to restrict the response to
certain values from the list I use this method:
In ("Value1","Value2",)  etc
How would it work if I wanted to restrict mutiple values.  Ie if there were

I want to edit information returned in queries but everytime I try too Access
wont let me.  The macro that opens the query clearly opens it in EDIT MODE.  
Whats the problem?

How can i lock a record so that the common user cannot alter its
contents after a comman button has been pressed.
Example:  I have engineers typing up information in to a record and when
they

i need assistance extract the following
12345 from 3001-12345Y
653 from 2007-653Z
23 from 4009-23p

I've got a large database where I want to delete duplicate records using a
delete query.  I've set up a totals query to determine which duplicate
record to delete, but I need a unique field in the duplicate records to tell
which one to delete.  I'm trying to assign an incremental ...

SELECT
IIf(IsNull(Sum([vend_div_vol]![vendvolume])),Sum([OPDS2_Div_Vol]![DivVolume]),IIf(IsNull(Sum([OPDS2_Div_Vol]![DivVolume])),Sum([vend_div_vol]![vendvolume]),Sum([vend_div_vol]![vendvolume])+Sum([OPDS2_Div_Vol]![DivVolume]))) AS Volume
FROM ((OPDS2_Div_Vol INNER JOIN ...

I am using the following SQL in Access to run a query.  I would like to limit
the number of  records returned in the Horse column to the lastest 25
(specified by DateOfRace).  So I'm NOT limiting the overall query to 25
records, but a subset groups of records in each Horse column ...

can I override a calculated field by typing in another number?

Is there a way to change the default ODBC time out on queries that connect
to a SQL server table?

I have a table that holds information about orders... it has 12 feilds.  The
original creator of the database didn't create separate feilds for the
pickup_address and pickup_state.  So, the pickup_address feild as data
formatted like this:

I have "invoice Numer" field and some records contains just number and some
begins with a letter. How would I query up invoices that contains
letter(alpha)?
not using like [a-z]*.  I don't want it to input a criteria, i want to run

Hi, There,
I would like to get your asistance to work an more effiicent query.  I can
accomplish the job by break the task into several queries and I believe there
should be a better way.