For employee movement tracking, I need get Year end employee number by
division. Table example is as follow:-
Div     StaffStart      StaffLeave
A       2005Q1        

I am provided a CSV txt file from an Oracle DBS. I import it into Access
so I can perform reports and other actions. (Don't ask why).
One of the txt fields has the following 'type' of information
"User: Wilson Frederick opened Facility: RM101 at 8/2/2003 05:44:11"

I am running a select query on a table with 10 descriptive fields for each
record.  I am using two field to set criteria.  The first select field is a 3
digit number.  I set the criteria on two lines. Criteria = ">0 And <=399" and
Or = ">399 And <= 999".  My query applies this ...

I have a FE subform that open a report using the following code with filter:
Private Sub btnDevOrder_Click()
On Error GoTo Err_btnDevOrder_Click
   Dim stDocName As String

I have two fields that are Date/time but not all the fields are filled in,
sometimes a date/time will be populated & sometimes a Blank.
So I tried to use DateValue([CLOSE_TIME]) but the blank cells are populated
with error.  

I need to pull records that have "Alert" in one field AND/OR "Red" in
another. They are both calculated. Is there any way around Access not
displaying calculated fields in Queries and Reports. I need to query by these
guys. help

I need to put more rows in a crosstab query.  I could put an unlimited number
in with previous versions of Access.  With 2003, I'm limited to 3 rows - any
work around?  I've changed my crosstab in design view but it won't stick.

I have a make table query in which I want to enter a field caption that
contains an ampersand.
When I save the query and re-open it, it inserts spaces around the ampersand.
Test&Caption: [FieldName]    becomes     Test & Caption: [FieldName]

This is probably very simple, but I can't make it do what I want! HELP!!!
It's a simple order database with products, dates and quantities... what I'm
trying to do is have a query simply give me how many total of each item were
ordered between a start and an end date. I can have ...

I have  query with some Criteria in Columns. If I want to modidy query, I
need to open query with Design view. How I can automate this step with
wizard or something?

I have crate a union query in Ms Access XP to combine 2 tables Customer &
Vendor.
Below is how the query looks like
SELECT strCustomerID as strID, strCompanyName, "Customer" as strType

I have a query that needs to multiply QTY * PRICE and QTY * PAY for 10
line items.  I was putting in all of the fields and their formulas when
I ran out of fields.  How do I add more.
This is a standard Select Query.

I've got a query that randomizes the order of entries. When I run it in
Access it works.
But I try to access it from Excel, and no matter whether I use the automatic
system that Excel has for updating database info or if I code it in VBA and

I received the above compile error in the following query:
Expr1: Round([AuxDatosParaRegistrosDeResult]![HandicapExacto],1)
The above field is a numeric double field coming from a linked table, so I
cannot modify this table.

I am a volunteer for an animal shelter.  I'm writing year-end reports t
help with grant applications for next year.  
Here's my problem. I am using the following code to extract co-paymen
data from a general comments field in my agency's animal data base an