Creating a database for quotes

C

Cest Cille

Is there any way to create a Database designed to store quotes and them in a
random order when requested?
 
S

storrboy

Is there any way to create a Database designed to store quotes and them in a
random order when requested?
Click to expand...


Store all quotes in a table with an Autonumber or some other unique
numerical field.
Use the RND function to randomly select a number and then use a query
to retrieve the quote with that number assigned to it. How you display
it will dictate the best way to retrieve it.
 
C

Cest Cille

Ok thanks, I've never really used Access since i was in school and that would
have been an older version, so I'm hoping that's not too difficult for an
amateur. Otherwise, I'll be back :)
 
C

Cest Cille

I've managed to create a table with the various items. Can you tell me how to
do the latter part(using the RND Function and retrieving using a query)?

Thank You
 
S

storrboy

I've managed to create a table with the various items. Can you tell me how to
do the latter part(using the RND Function and retrieving using a query)?

Thank You
Click to expand...


How will you be displaying it? In a form like a program Quick Tips
message, message box, report?
This will determine the best way to do it.
 
S

storrboy

Also, give a summary of the fields you are using and what their
datatypes are if it's not obvious.
 
Q

qiu zheng ting

??? ????????
storrboy said:
How will you be displaying it? In a form like a program Quick Tips
message, message box, report?
This will determine the best way to do it.
Click to expand...
 
C

Cest Cille

The Only fields are the Quote and the number of the quote, I would like it to
pop up in a message box if possible......

Thanks!
 
Top