Use Randomize And Rnd In The Same Query To Get Real Random Choices

May 14, 2006

The queries go like this at present :

SELECT TOP 1 [Table].[QuestionText], [Table].[Answer] AS CorrectAnswer
FROM [Table]
GROUP BY [Table].[QuestionText], [Table].[Answer], rnd([IDQuestion])
ORDER BY rnd([IDQuestion]);

SELECT TOP 3 Table.Answer AS Correct, qQuestionTextAndAnswer.QuestionText, qQuestionTextAndAnswer.CorrectAnswer
FROM [Table], qQuestionTextAndAnswer
WHERE (((Table.Answer)<>[qQuestionTextAndAnswer].[CorrectAnswer]))
ORDER BY Rnd([IDQuestion]);

These queries are displayed now in an Access form "frmQuestions" which is applied to "Table" that has three columns id, text , and answer. The result is one question and four suggested answer with one only being correct.The arrangement of the answers is randomized--
but the choice of the question is not realy random....it always starts with the same question as it relies only on rnd.

can I improve the queries and randomize and rnd in the same ...or else can I switch these queries to be used from vb6 code and achieve that result.

any help would be appreciated.

By the way I am really a beginner at this who is seeking help from the experts.

View Replies


ADVERTISEMENT

Forms :: Combo Box Where List Of Choices Are Narrowed In Real Time As You Type

Sep 29, 2014

I would like to create a combo box (or something similiar if a combo box simply can't do it) where the list of choices in the pulldown shows only the matches of what a user types in. The list of choices are coming from a field in a table. Also I would like the "search" of the user's input to include what is "within" each choice, e.g. if a user type "ber", then valid results should be bertha, october, robert.

View 1 Replies View Related

Multiple Choices On A Query.

Aug 3, 2005

Hi All.
I currently have a query that runs a report. The "Project_Status" field of the query is decided from a combo (cboPS) that is on a form (frmReportManager). The user selects the status from the combo and clicks a button to run a report with that status. That is all OK.

What I would like is 4 tick boxes on the form with the 4 project Status (Ongoing, complete, invoiced and quote). The user would then choose the status types he would like in his report, not just the one type as in the combo.
How do I go about referencing the 4 text boxes for the status types, to the one field in the query (Project_Status).

I have tried using And and Or, but with no luck.

Czn anyone help?

Many Thanks.

Frank.

View 14 Replies View Related

Parameter Query With Possible Choices?

Feb 27, 2006

OK, this has to be simple, I know...But I cannot figure it out.

I have a parameter query that works great, however, it has become complicated to remember all the values the field can have and so sometimes it is difficult to find the info needed. How can I do it so that instead of having an empty box pop up when the query needs my parameters, I get a list of possible choices??

Appreciate the help

View 5 Replies View Related

Query Selection - Multiple Choices, One Field

May 19, 2005

I have a database which keeps track of a trucking business. Each truck has a trailer number. I have no problem having a query prompt the user to enter a single trailer number to query on. What can I do when the customer needs to select more than one trailer number to query on?

View 4 Replies View Related

Real Simple: Add Together 2 Numbers In Query?

Aug 26, 2005

Hello, how do i add 2 field numbers in a query together, i have the fields: "basic hours" & "overtime", and a "total". I would like the "total" field to add basic hours & overtime together.

I believe i need to use the =sum function in the query on the criteria bit, is that right?....but forgot what to do :o please help?

View 10 Replies View Related

Text String From Form Query - Multiple Choices

Aug 12, 2012

Been a while since I put hands on access. Working with a very simple database.

Working with 1 table, 1 form, 1 query.

Query has several fields. Field of interest contains names of counties.

In query design view I can type, "CountyA" Or "CountyB" or "CountyC" in the criteria and the desired results are returned.

On form I've created a text box and an open report button. The report I'm trying to open uses the query as the data source. I reference the text box on the form as the criteria for the query as follows:

[Forms]![frm_LMIBasicReport]![txtCounties][Forms]![frm_LMIBasicReport]![txtCounties]

If I enter the the name of a single county into the form it executes perfectly. If I try to enter multiple counties it fails. This is true whether I just enter the county names or replicate the exact criteria string I use in the source query. For example

CountyA works and returns desired values for County A
CountyA Or CountyB or CountyC fails. The report opens but no records are returned
"CountyA" Or "CountyB" or "CountyC" = exactly how it is entered in the query if I'm not using the form opens report but no records are returned

How can I pass multiple values from a single text box to the query.

View 1 Replies View Related

Randomize A Column

Sep 19, 2006

I have about 100 quiz questions in a MDB File. I need them to be randomized.
I've done a pseudo-randomization of the questions by a certain column by using the ascending/descending order, but it is awfully obvious!!!

Is there a way to do it so it's like an ipod shuffle. Is there a way to randomly mix all the questions up WITHOUT the need to randomize by virtue of ascending/descending order of a column?

Thanks

View 1 Replies View Related

Randomize Recordsets

Feb 21, 2007

My query randomizes the records, but i want it to be different
each time the page loads/refreshes.

Query:
Code:"SELECT * FROM tblImages ORDER BY Rnd(ID)"

I have tried many variations but cannot find one that works,
anyone here know of one that will achieve this.

Thanks
Shem

View 3 Replies View Related

Randomize Into Groups

Jan 2, 2008

Hello all,

I need to randomise participants in an Access 2000 db into four groups. Let's say these are 1, 2, 3 and 4. This in itself is not the problem. The problem is that I need to keep the numbers of participants in each group approximately equal, say to within a tolerance of 4.

Can anyone point me in the right direction please?

Thanks very much.

View 4 Replies View Related

Randomize 2 Columns Separately.

Nov 25, 2006

I have read a lot about the rnd function to succesfully randomize the order of records in a db.
I want to randomize 2 columns separately . These are Q's and A's so if the db is 2 fields (the second -small- letter is supposed to be under Field 2!)
Field1 Field2
A a
B b
C c
D d

etc...
I want it to look like
Field1 Field2
B c
A d
D b
C a

I have managed to construct two separate queries which obviously give 2 random lists for each field but how to put them both together to achieve the above?
I have tried applying a rank order to each list and then linking them on that but the rank number keeps changing hence no link there. All I want is to link them and keep each column in the same order as it has been randomized.
Thanks

View 6 Replies View Related

Requery/Randomize Not Working

Oct 13, 2006

I want to return all the records in a table in a random order. I have a query with Expr1:Rnd([RecordID]) sorted ascending as one of the fields. I have a form with this query as the data source.

This works fine, each time I open the form, I get a different record order.

I now want to use Randomize to return a different order each time I run the database.

Using advice from other threads about randomization, I have put the Randomize in the OnLoad event of the form, immediately followed by Me.Requery, but I still get the same first record each time I open the database.

I put Rnd() in a MsgBox after Randomize to see if the randomization is working, and I get a different number every time, it just seems that the Requery is being ignored.

Any ideas?

View 10 Replies View Related

Queries :: Randomize Selected Group Of Rows

May 9, 2013

I have a table (tbl_entry) of performers and the different sections they are performing in. I can pull the performers for each individual section but is it possible to then give the performers a random number that will indicate the order in which each will perform. Eg: 5 performers in section 21a

Molly
Mary
Mike
Merv
Mandy

So can I get access to randomly assign numbers 1-5

View 1 Replies View Related

Query To Select 20 Random Records

Aug 9, 2007

As part of my job, each month I have to select 20 problem report resolutions and grade them on quality. Typically we have about 100 problem report resolutions per month. Is there a way I can use a query to return a random selection of 20?

Thanks,
Jim

View 1 Replies View Related

Select 20 Random Records In Query

Mar 12, 2008

I have to review 20 reports each month for quality check. I have a query that lists the reports completed within the past 30 days. Is there a way to filter this query to show only 20 random records?

If there is no way to do this, can you suggest some way of doing this so that it's impartial? For example I don't want to select the first 20 of the month because everyone will catch on and wait late in the month to post their report. Normally about 70 reports are completed in a month.

Thanks,
Jim

View 3 Replies View Related

Random Query Excluding Selected Group

Sep 24, 2005

I have a table with RandomID, EmpID, CompanyID. Some Companies will have great than 25 employees. I need to setup a query where I can randomly select all employees from all companies whos employee count is less than 25.
I have tried the following:
SELECT top 10 percent Count(*), empID
FROM tlbCompany
Group By empID
HAVING Count(*)<25
ORDER BY rnd(RandomID);

This counts the total number of employees, so if a company has 10 employees, it will only display one of the them.
Can this query be done?
And, what am I doing wrong?

Thanks to all that help....
Enviva..

View 5 Replies View Related

Update Query With Rnd (random Numbers) Question

Nov 30, 2006

Hello Everyone,

Im trying to make a query which will allow me to run a query update so that all my listings will get a new random number generated for them,

Ive got it selecting any listing with a ID of >0 (so basically thats all of the listings)

What id like it to do is then assign a random number to the randsort field, (prefer a number like 0.812 or 0.342 etc etc)

To start with ive tried using the Rnd feature, but its updating all the listings with exactly the same number (though granted the number changes each time the query is run)

I see in some of the other comments regarding rnd that you may need to put a randomize statement somewhere,

Im very new to programming in access and was just wondering am I on the right track, and if so where abouts should i declare the randomize code since its in a query?

Thanks for your time and look forward to your replies
Cheers Ezy

View 6 Replies View Related

Select Equal Type - Based On Random Query

Oct 6, 2006

Good Afternoon Everybody,

Apologies for imposing on you all but I was wondering whether or not you could help me out??

Would you be so kind as to kind as to show me a practical example of how to incorporate a facility into my attached Database which serves to select an equal ratio of my field “SectionHeadings” such that out of the 30 “random” questions that it currently generates it will provides me on completion with the following:

5 From Set1
5 From Set2
5 From Set 3 …..etc etc

It currently generates the 30 questions that I need without a problem; however it routinely selects any number of one particular type, sometimes more from one subject and less of another.

All subjects headings are of equal importance to me and as a consequence would be very grateful if you could look at what I’ve already done and show me what needs to be done in order to achieve my aim.

I hope my request is possible - Any help you could give me would be very much appreciated. Thank you very much.

Best Regards

CarolW

View 5 Replies View Related

Queries :: Generating Random Time From List In Query

Apr 29, 2015

I am trying to create a database to link to an online auction site (not ebay) and I want to create a query that randomly generates auction end time and auction length for all listings. I have tried int(rnd()) and various versions but can only generate the same number for all fields in the query.

View 1 Replies View Related

Queries :: Query For Inserting Random Records Into Temporary Table

Jul 16, 2015

I'm trying to insert 10% of a dataset from dbo_billing into another table Random_Temp. Another form is open when this query is to be ran that passess in the billyear and billmonth... I'm sure it's a syntax issue as I can isolate the random number part and it displays the appropriate data, I just can't re-write it to insert into the other table:

INSERT INTO Random_Temp ( indx, peopleId, audited )
SELECT TOP 10 PERCENT b.indx, b.peopleId, b.audited
FROM dbo_Billing AS b
WHERE (((b.billYear)=[Forms]![billing]![billyear]) AND ((b.billMonth)=[Forms]![billing]![billmonth]) AND ((b.recertifying)=-1))
ORDER BY Rnd(-(1000*b.indx)*Time());

View 2 Replies View Related

Queries :: Create And Order By Random Number In Query Field

Jan 2, 2015

I'm trying to create a query that generates random numbers for each record, sorts them by that field, then selects the top record. This should randomize the record being selected.

I can use the Rnd([ID]) function which does appear to generate a random number. Problem is that each time I exit the program and come back in, it always selects the same record. When I remove the Top = 1, to show all the records, every row does have a different random number but it does not appear to be sorting by this field.

If I run the query, here is the number I get: 0.98609316349029

Exit the program, restart, and run the query again: 0.98609316349029

If I refresh the query, the second and third time does appear to be random but the first result is always the same. how to generate truly random numbers?

View 7 Replies View Related

3 Choices

Oct 24, 2006

Hello,

I have an option group with check boxes on my form that updates a yes/no field in a table, so the choices the user used to have were check "something A" or "something B". Now I have to add a third choice of "nothing" to this.
Is there a way to achieve this with my current setup, or do I need to add a field to my table so that I can have the choices of "something" or "nothing", and then of "something A" or "something B" if the user choses "something"?

Thank you.

View 14 Replies View Related

Lots Of Choices

Dec 15, 2006

In this database, there is a table of users (name, address, phone, etc.) There is also a table of 35 groups. Each user may be in any combination of 1 or all of the groups. The list of groups is not static. At any point in time, I need to be able to show that Bob is in groups 1, 19 and 35. All I can think to do is list all 35 groups in the user table, then make each one a yes or no field. HELP! There’s got to be a better, more efficient way.

View 3 Replies View Related

Limiting To Just Combo Box Choices

Dec 20, 2006

Hello,

I am figuring this must be an easy question. I have combo boxes setup and working great. I just noticed that I can put my own text into the box and not be limited by just the choices in the combo box. If that makes sense.

When I try to lock the boxes then it doesnt allow me to select. I want the combo boxes to be the only selection they can make, and not be able to put their own text in.

Attached a screenshot to help clarify.

Anyone know what option I am missing?

Thanks.

View 2 Replies View Related

Best Way To Group Combobox Choices?

May 9, 2005

I have a combobos using a table to look up its values, no problem. The table could have several identical values to place in the combo box ( same city, State multiplt times). I want to group these so that the city, state will only show once in the combobox, hence makiing the list a little shorter. is the best way to do this by creating a new query to group the choices and base my combobox off this new query? or is there another way from within the combobox properties?

Thanks all
Kevin

View 3 Replies View Related

Hide Some Choices In Combo Box?

Oct 26, 2006

I have a combo box populated from a table containing names. Whomever processes the order selects their name from the combo box. Some entry persons have left the company but I cannot delete their names from the table as the orders are stored with their names and I want to maintain that history. Is there a way to hide their names from being displayed in the combo box?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved