Creating a database for quotes

[Guest]

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

 

[storrboy]

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

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.

 

[Guest]

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

 

[Guest]

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

 

[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

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.

 

[storrboy]

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

 

[qiu zheng ting]

??? ????????

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.

 

[Guest]

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!