Hi;
We want to devide records of a table to 4 equal parts and in each step work
on one part of them.For now,i can just select the first part,using this
query:

I am trying to create an active employee list.
Essential table structure is as follows:
tbEvents  (a table holding all employee and applicant actions)
-pkeventid  (primary key - autonumber)

I have created a query which I want to use to filter out all records
in a table that have an entry in a certain field.  The field will
contain text - therefore the criteria needs to instruct the query to
pull through all records that have text in that field - any text.  Can

My cursor jumps all by itself to wherever the mouse pointer is. It does this
after typing a few characters.
I'm typing a line. The cursor is of course at the text entry point. Then
BANG, the cursor jumps to where the mouse pointer is without ever touching

How do i remove an append query?

I have used an example from the Northwind sample database to write a query
to show running totals for the current year, but I am hust getting an error
in my running total column. Can somebody hae a look at my SQL and possibly
give me some ideas about where I am going wrong

Seems like something simple, but I can't figure out how to do this update
query (for just one column in the table.)
I need to replace first 6 numbers with an asterisk and keep the rest of the
numbers, i.e. replace 123456789123456789 with ******789123456789

I inherited a database in a mess.  I ran a query to get following columns:
salesman
first date (first date of sale to company location)
last date (last date of sale to compnay location)

good day all,
 I have an update query based on queryshipmentrequest, I have the following
relevant fields in my query:
shipmentrequest yes/no checkbox

Hi! everybody,
Could anybody help me in solving the following prob.
I had three tables
[P_list] -fields are [PrID], [Pname]

I've created a Microsoft Access2000  form in which users can select several
parameters for including or excluding data on a report
All brokerage firms or an individual brokerage firm can be selected, all
regions or an individual region can be selected and all reps or an individual

I have a table and would like to get cumulative totals like the following
format
Date    Result       CumulativeTotal
Jan1    1                      1

i have linked an excell spreadsheet with access and have created a search
querie with paramaters.  so lets say i want to pull up all invoices from
01/01/2005 -01/15/2005. when i click on the querie the enter start date shows
up and then enter end date it does this twice then it ...

How do I write the criteria for a field of the type date/time?
I want all records in a given time frame - e.g. from January 5, 8am to
January 7, 2pm

I need the syntax in SQL (or Criteria) to find the most recent date in
table. table contains IssueID, ProgressLog, and ProgressUpdateDate. I a
trying to get most recent ProgressUpdateDate inthe table. IssueId ca
have more than one progressLog. I need to get most recen