Query Confusion

[KKawahata]

Currently I have two tables one with many many datafields detailing my
companies projects another which tracks payments as related to each
individual project by a datacode. This way I can have individual
projects with multiple (sequential) payments which was essentially the
purpose for creating our new database. Now the problem I'm having is
when I try and run a Query on the tables to collect the relevent data.

Whenever I run a query to list a specified group of data from the main
table (I.E. InProgress projects) and I want to include the last payment
made (in the form of a date and an amount) I can only get data from the
main page that has payment information. In otherwords if a project
hasn't had any payments on it yet but it still fits my InProgress
requirement I don't know how to retrieve it. Thank you all for your
help.

 

[Jeff Boyce]

Already answered in your post to the tablesdbdesign newsgroup. While it is
rarely necessary to post to more than one 'group, if you feel you must,
please select the newsgroups as your "To:", rather than posting separate
messages to each. This way, an answer in one newsgroup shows up in all the
"To:" groups.

 

[KKawahata]

thanks sorry.