need help with building querys

[ShaunG]

I have built a query that brought 3 tables together and was working fine, until I created another query with the same fields.. now I cant get the records to show up on form that was working fine previously.



is there any in depth tutorials on building querys that can help me?

[isladogs]

There must be something different about the 2 queries e.g. filter criteria
If they really are the same fields, use the first query that works

BUT if you have inner joins and one of the tables has no corresponding records, the form will be blank

[ShaunG]

There must be something different about the 2 queries e.g. filter criteria
If they really are the same fields, use the first query that works

BUT if you have inner joins and one of the tables has no corresponding records, the form will be blank

you are correct they are slightly different and there is inner joins, I open the wrong query up and changed things round then when I realised I tried to change it back but I couldn't work it out, it was blank and fields locked.

I finally worked out the issue, I wasn't including enough fields from the 3 tables, this is where I don't know much about the query side of things.