OK i have search thru thends of this forums and i can not figure out how to
use the RND function.
Please be specific when responding to this
I have 6 tables, each consist of 8 fields, question, question #, a answer, b

I am having some problem in conversion of access queries to SQL server 2000
stored procedure . I have exported Access tables to SQL server 200 easily but
i a mfacing some problem in conversion of Queries of access

I have a table (tbl_BibleBooks) listing the books of the Bible.  Fields are:
fld_BibleBooksID (Autonumber)
fld_BibleBooks (Text)
I created a simple query to sort the list alphabetically. Rows as follows:

I have a crosstab query which is returning a blank (null) column with a
heading of " <> ".
I have never seen this before.
Please help, Frank

Is there a place on microsoft's website that i can learn all that the above
can do within queries?  Or at least list what they might be able to do?
Thank you in advance.

I need to write a query that would be based off of what kind of training
someone has. My information is stored as 1's & 2's as it is entered from a
data entry form that contains option buttons. Basically there are two kinds
of training- OSHA or CPR/First Aid. OSHA is stored as a ...

I am trying to create a query that returns name and address data for a
customer and date, type, and amount data from the last transaction for that
customer.
The max(transaction date) function returns the last date, but if I add other

I have a db with a linked table to an Excel worksheet. I have several update
queries that are used to update data in the linked Excel worksheet.
Everything works, but I get asked on each update this action will update
data in the table, do you want to procede.  I have all the ...

I have a table that has the employee name above and the stats below.
For Example:
Field1                     Field2
2005 - Doe, John

I've created an access query of which I'm trying to "summarize" by part by
customer.  Example of query "raw data" and what I'm attempting to summarize,
below:
"Raw Query Data"

I am working with a query trying to return the earliest date greater than a
specific start date.
Example...
Start date = 1/1/2006

Ok i just type this and didnt come thru so if you see this twice im sorry
I need help with the rnd function.  I cant get it to work.  I have search
thru the forums and was unable to get it to work.
So i have a table that has 8 fields,  question #, question answer a, b, c,

I have received an Email with the above attachment.
I cannot open the attachment. What should I do to open it?
Thank you.  
W.E. Richards.

I am trying to write an IIF then function that evaluates two fields to
determine what the result should be and I'm having trouble.
Example of what I'm trying to do:
iif([field 1]="R" & [field 2]="3","K",[field 1])

Ok, I am baffled.  I have tried numerous things.................
I want to let the user select the criteria to perform a search. Then I would
like to export the search results to excel.
(Sample code if user selects an ENTITY.  If they select more than one