Make Table Query in a Report
- Thread starter KirkComer
- Start date
Neil,
Thanks for the repsonse. I am new to Access and I am trying to learn how everything works. Let me take another stab at the question.
I have a "new" table that uses a make-table query to update the information that is coming from a "main" table that has information being fed by a data entry person.
I have a report that I am using to show the "new" table information.
My problem is that when I run the report the "new" table information is not updated.
I realize I can run a simple query to get the information but I was just curious to see why the "new" table does not update and I can't select my make-table query to use for my report.
I apologize it I'm sounding too confusing. I've still got a lot to learn. This forum has already helped me with several questions I have had. You guys are great!
Thanks for the repsonse. I am new to Access and I am trying to learn how everything works. Let me take another stab at the question.
I have a "new" table that uses a make-table query to update the information that is coming from a "main" table that has information being fed by a data entry person.
I have a report that I am using to show the "new" table information.
My problem is that when I run the report the "new" table information is not updated.
I realize I can run a simple query to get the information but I was just curious to see why the "new" table does not update and I can't select my make-table query to use for my report.
I apologize it I'm sounding too confusing. I've still got a lot to learn. This forum has already helped me with several questions I have had. You guys are great!
R
Rich
Guest
You have to Save the Record before you can view it on a report but why are you using a make table query? 
Rich,
Thanks for you reply.
To be perfectly honest. I don't know what I doing yet. I'm attempting to learn on the fly. I am trying to explore what I can and cannot do. My new job is requires me to do almost everything through Access 2000 and SQL Server 2000. Most of the work has been done in the past through VBA so I must also learn a lot about that. I'm really trying to cram things in my hard head quickly.
Do you know of any GOOD books or resources that are available?
I bought Access 2000 for Dummies and that has been somewhat helpful.
I also bought Access VBA Programming for Dummies but it seems like everything I try from that book doesn't want to work right.
I am also taking classes at a local community college but classes are only once per week and I've only been through one class.
-Kirk
Thanks for you reply.
To be perfectly honest. I don't know what I doing yet. I'm attempting to learn on the fly. I am trying to explore what I can and cannot do. My new job is requires me to do almost everything through Access 2000 and SQL Server 2000. Most of the work has been done in the past through VBA so I must also learn a lot about that. I'm really trying to cram things in my hard head quickly.
Do you know of any GOOD books or resources that are available?
I bought Access 2000 for Dummies and that has been somewhat helpful.
I also bought Access VBA Programming for Dummies but it seems like everything I try from that book doesn't want to work right.
I am also taking classes at a local community college but classes are only once per week and I've only been through one class.
-Kirk
neileg
AWF VIP
- Local time
- Today, 05:14
- Joined
- Dec 4, 2002
- Messages
- 5,975
To add to Rich's observations:
It is a general rule that you don't hold data more than once. So if you are using a make table query simply to base a report on, you shouldn't. The samer query as a simple select query will rovide the dat on which to base the report. Again, it is a general rule that reports and forms are based on queries, not tables.
It is a general rule that you don't hold data more than once. So if you are using a make table query simply to base a report on, you shouldn't. The samer query as a simple select query will rovide the dat on which to base the report. Again, it is a general rule that reports and forms are based on queries, not tables.
