insert new record into table from a query

[rwahdan1978]

Hi

I have the following query:

    Dim rs3 As Recordset
    Set rs3 = CurrentDb.OpenRecordset("select * from users order by score desc")

from the query I am showing current winners in the game: Name, Score and winner photo (from the query above). Before playijg a new game I want to add this record to my table:



How to do that?

[June7]

Add what record - another game? Why not do data entry?

Your data structure is not normalized.

How can a game have multiple winners?

[Micron]

To my comrades: I looked at OP's thread history. I stopped looking after 10 threads; not one of them was acknowledged as solved. All dropped and last to post was someone trying to help. Expect the same here I guess.

[davegri]

To my comrades: I looked at OP's thread history. I stopped looking after 10 threads; not one of them was acknowledged as solved. All dropped and last to post was someone trying to help. Expect the same here I guess.

Yeah, I noticed that too and was even considering a post like yours. I spent considerable time on replies to this individual, with NOTHING acknowledged.

[Welshgasman]

I hate the one sthat come back and say 'It is OK, I solved it' but then do not say how

All take and no give.