report random query

[patatrac]

ciao for all
i have a query random:

id questions answers
1 xxxx ccccc


2 qqqq vvvvv
3 zzzz fddfdd
4 xxxq fsffsfsf
5 qqqqs gfgggfgfgf

and 2 reports limit 3:
reports questions ( ok with random questions)
reports answer ( my problem where i would visualize the random id+answer displayed of first report). I search in all way but unfortunately without solutions...
thank for help me
example:
in my first report is display

id questions
2 qqqq
4 xxxq
5 qqqqs

i would in the second report solution with answer

id answer
2 vvvvv
4 fsffsfsf
5 gfgggfgfgf

my problem is the random

[June7]

You want query to retrieve a random set of records?

Bing: access query random records

http://www.techrepublic.com/blog/how...rosoft-access/

[patatrac]

the question is simply
you look Report1 and Report2 have recordsource Report_print

Report1 have id 35 37 38 51 52
Report2 have id 35 38 39 52 53
how is possible have:

Report1 have id 35 37 38 51 52
Report2 have id 35 37 38 51 52

first open Report1 and after Report2 and have equal id

I serch way to clone the display Report1data in a table eg TblClone , and after build the query for Report2
with relation Tblclone ID_Questions = TblMainQuestions ID_Questions
i think this is the way but I dont think how made it

[June7]

I don't understand.

[patatrac]

my question is :
query random every open Report1 change my IDs (and this is ok , is random...)
I would that with open Report1 netx step open Report2 and compare in Repor2 equal IDs of Report1

[June7]

Well, if the query is random then the two reports will not retrieve exactly the same records. That's the nature of 'random'.

Why would you need to compare reports?

[patatrac]

Report1 are questions Report2 are Answers

[June7]

These are the correct answers for each question or they are respondents' answers?

Regardless, do a query that joins questions and answers then pull random records from that query.

[patatrac]

test.zip
Thanks for answer but i don't understod very well...
i add file
shift button press on open file,

Report_Print the query that is command with random Variabili query
Report1
Report2 (my problem..)

I would open Report1 (questions) and after with Report1 open.... open Report2(answer) with equal id
My solution is
On open event Report1 save in a table IDs , on close delete IDs
but i don't able release it

[orange]

Readers do NOT understand your post.
Show us an example -- starting values and what you want as final values.

You can use your native language, then Google translate to get English.





I lettori non capiscono il tuo post.
Mostraci un esempio - i valori di partenza e quello che vuoi come valore finale.

È possibile utilizzare la vostra lingua madre, poi Google translate per ottenere l'inglese.

[patatrac]

test2.zip
Open Report1
report1 have On event open
1 generate a table Answer
2 add id (is this my problem...I would that when I open Report1 in my table Answer INSERT all my display IDs noT only one)

on event close
1 delete table Answer

[orange]

I get an error as soon as the database attempts to open.

[orange]

Not any clearer to me.

When you post the same question on multiple forums, please tell users you have done so.

Assuming Italian:
Quando si registra la stessa domanda in diversi forum, informi gli utenti che avete fatto così.

[patatrac]

ok the question is in a multiple forum ..sorry , is no important the error when open the database ,
I would save in the table Answer all the id diplayed to Report1 (when open)

[orange]

Readers do NOT understand what you are trying to do nor what your descriptions mean.

You have been given answers in different forums and have not commented on these, specifically.
??????

I would save in the table Answer all the id diplayed to Report1 (when open)