Showing Search In Report

[Computer202]

Hi Guys,

First off, I am new to Access but I have used Excel a lot and have made a few databases etc. It has come to that time where access is the better option for soooo many reasons lol mainly speed

I have a database which contains 1 table; tblPS2, this is not normalised yet that will come at a later stage.



What I would like to do is exactly what the attachment does. What that does is as follows: It is designed to search the PS2 sheet for anything (mainly designed for name), you can enter the search criteria anywhere on the Entry page, When this cell with the data in is selected you click the macro and it searches the PS2 sheet... When it finds all the matching entries it copies them and then pastes that row onto sheet Results. Then this is repeated for more items.

The Idea is in access it works as follows,

Search criteria Entered,
Search brings up options in SubForm,
Correct Result Selected (preferably tick box),
It then copies this data to temporary table,
Then makes a Report, From template?,
This form can then be save (and no longer live, I want to be able to delete the Table contents and the report to show the same data),
Then I will create a delete query which empties the table for the next search batch

Summary:

I want it to produce a report of Say 10 different games and all their data within the Table including calculated fields and be possible to archive.

P.s Italics means I am capable of doing!

Would appreciate Assistance

Cheers

Dan

[Computer202]

Sorry to broad I know, I have found a work around but posting a new small size problem which is easily solvable in a line