How to place two Images on one form ?

[CJ_London]

where do i find the SQL of the query ?

The sql was provided as a template in post #9 with a detailed explanation of how it works then provided again in post #12 modified for your actual table/field names. I've provided further code in post #17 around sorting and filtering. You can see the sql you originally provided in the recordsource to your form.

I'm sorry if you feel this is beyond you but as Mike says - you need to start somewhere. Your requirement is not straightforward in access - but can be done as I've demonstrated. You just need to get your hands dirty and make a start.

 

[arnelgp]

another sample.

 

[Gasman]

O/P has now cossposted https://www.utteraccess.com/topics/2063143?post=unread

However they did have the courtesy to notify that forum that they has crossposted and acknowledged the solution posted here,

@Adi44 we all started where you are now right now. I am self taught and learnt from this and other forums, but was prepared to learn.
One of the respondents in this thread will write all the code for you, but the problem there, is you will come back time and time again with 'That works, but now I want to.......' and it just goes on and on.

Have a go, you will surprise yourself.

 

[Mike Krailo]

There is a lot of potential in using a web browser control if you know how to use it. Nice sample Arnel. I bookmarked that table generator site too.