newbie2181
Technical User
Hi there,
I have a database that has a table and a report. The table contains a lot of data and i need to filter some out for printing on the report. To achieve this i thought i would set up a query to run on that table and then set the query as the record source on the report. this is all fine except i am having a little trouble with the query. I need to display two types of data from the table, first is all records from the Transaction field that equal "New business" which i have got working easily. The next bit however is that i also need everything from the transaction field that equals "renewal" with policy number starting "GL56".
Can anyone give me any pointers on how to go about this?
Thanks
Dan
I have a database that has a table and a report. The table contains a lot of data and i need to filter some out for printing on the report. To achieve this i thought i would set up a query to run on that table and then set the query as the record source on the report. this is all fine except i am having a little trouble with the query. I need to display two types of data from the table, first is all records from the Transaction field that equal "New business" which i have got working easily. The next bit however is that i also need everything from the transaction field that equals "renewal" with policy number starting "GL56".
Can anyone give me any pointers on how to go about this?
Thanks
Dan