Access 2000
My database project has a field that contains multiple offenses per person,
and I have set up a MEMO field for the Offense(s) category.
Example:  

I would like to generate a serial number as first column in my query result.
The query result is a dynamic one and based on the number of records it
results, the numbers should be displayed. My basic requirement is that I need
the query to be executed in the MS Access 2000.

I need to filter 8 pay periods (PP) from user selected PP.  For example if
user select PP 12, I need to show every entry between PP 5 and 12.
I have set up following criteria in fields CompYear and CompPeriod (I am
just showing the last part of the criteria, [Forms]![frmSelect] is ...

Access 2002
I am trying to combine several fields into 1, and I would like to set it up
in a query, rather then a report, because I will be using this output in
various reports.

I have a table that has a field called "Type". It is a combo field that has
values:  Revision and Review.  Based on the selection, there is another field
in the table called DATE.  So, there can be a selection called Review with an
associated DATE and a selection Revision with an ...

Need help with using the Datediff function, first off i am not sure if that
is the right function to use but what i am trying to do is to calculate or
generate the current age of a person. This what i have at the moment
Age: DateDiff (yyyy, date(), [DOB])

I'm hoping theres a really easy answer to this and i'm just being dim :) I
know how to write a query and open the query using a command button but i
would really like to have a field at which says name:______, when someone
enters a name eg smith, and hits return a new table would ...

I have a problem where I have two databases with similar table structures
that need to be combined. I have run a File - Get External Data - Link
function from one of the dbs and now have two copies of each table. The
original one from within my db and a table with a '1' at the ...

In my database one person with unique code may have multiple rows with same
variables. Consider history of smoking; person with code=40 has three rows,
each row includes id , start age of smoking, end age of smoking and type of
cigarett. As this subject, used two different type f ...

           DoCmd.runMacro "FRM-CR10RW"
           ALTER TABLE DPS_FR_CR10RW CASEID INT ADD CONSTRAINT
(CASE_NUM_YR,CASE_NUM) PRIMARY KEY
Getting Compile error, expecting end of statement.  I need to create a

Hi Group,
I am using the Orders database supplied with A2K.
I have data like so...
Customer ID            Total Sales    Payment     Balance

I have a database which records fitness test results of pupils.
There are the usual name fields and then a series of fields holding results,
e.g. field BP1 and field BP2; each of these fields holds a test result in
numerical form. Let's assume BP1 value is 55 and BP2 value is 57.

I have modified an Access Template called Order.mdb to record all Ticket
Orders and Donations for a fundraiser we're hosting.  All of the individuals
for whom tickets/donations have been purchased are listed as "products" in a
separate table.  Each "product" has received either ...

I want my query to include everything but MDN and M with two numbers like M10.
I tried<> M** and<> M??, and <>M##. None of them worked.
Thanks for any help
ed

I have a database which records fitness test results of pupils.
There are the usual name fields and then a series of fields holding results,
e.g. field BP1 and field BP2; each of these fields holds a test result in
numerical form. Let's assume BP1 value is 55 and BP2 value is 57.