 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007Creating a database for quotes
Is there any way to create a Database designed to store quotes and them in a random order when requested? On Mar 12, 3:03 pm, Cest Cille <CestCi...@discussions.microsoft.com> wrote: > 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. 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 :) > On Mar 12, 3:03 pm, Cest Cille <CestCi...@discussions.microsoft.com> > wrote: [quoted text clipped - 6 lines] > to retrieve the quote with that number assigned to it. How you display > it will dictate the best way to retrieve it. 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 On Mar 13, 2:28 pm, Cest Cille <CestCi...@discussions.microsoft.com> wrote: > 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" <storrboy@sympatico.ca> ??????:1173841303.491112.230390@e65g2000hsc.googlegroups.com... > On Mar 13, 2:28 pm, Cest Cille <CestCi...@discussions.microsoft.com> > wrote: [quoted text clipped - 7 lines] > message, message box, report? > This will determine the best way to do it. Also, give a summary of the fields you are using and what their datatypes are if it's not obvious. 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! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.