I am creating a helpdesk system in access. I have completed all the facilities to add tickets but now i need to be able to display different tickets depending on its status.
I thought a querie would be the answer but i need to display the returns in the format of the forms not a table. is it possible to do this?

Just make the query the datasource of your form.