Query Expression to Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Query Expression to Table

Robert Sena

4 years ago

Rick Wanted me to post pics and explain what I am trying to do.

I have a database where I have users report product quantities and from their entries, progress payments are generated to the contractor. The queries of how I came up with the payment amounts are attached. I also built one query which only summarizes the payment amounts. I want to somehow tie my PayEstimateID to my summary derived from the query and move the summary values to a table for permanent record. I am having an issue with the PayEstimateID. I am not getting the option of getting a new PayEstimateID to tie to estimate summary queried.
Not sure if you can help but it is worth a try. Just something I'm not seeing. Maybe the relationships are incorrect. Thanks. Pictures to follow.

	Robert Sena OP @Reply 4 years ago

	Robert Sena OP @Reply 4 years ago

	Robert Sena OP @Reply 4 years ago

	Robert Sena OP @Reply 4 years ago

	Robert Sena OP @Reply 4 years ago

	Robert Sena OP @Reply 4 years ago

	Robert Sena OP @Reply 4 years ago

	Richard Rost @Reply 4 years ago
Without the appropriate context and understanding of what you're trying to do, I'm afraid this is all just Greek to me. Explain it to me like I'm a 3rd grader. Don't assume I know what PayEstimateID means. See Context.

	Robert Sena OP @Reply 4 years ago
You are correct. I figured it out. Thanks for responding. It was easy once I put it all together. There is still a lot for me to learn. VBA makes building a database so much easier. I'm learning slowly but surely.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View