relocation of data....gives table1. before everything

[rscott1989]

Hey!

Ok everyone I need some help! I have been working on the same project for several days now. I must have done something because everything now has a table1. before the name. This is messing everything up, my calculations arent working anymore! I dont know what I did!!

 

[jdraw]

Suggest you write a short paragraph to tell us about your project. Perhaps some samples of what you expect to happen.
It would also be helpful to the readers if you could show us a jpg of your tables and relationships in the form of a zipped jpg file. If you zip your data, you can send an attachment before you have reached 10 posts.

 

[rscott1989]

Ok, I think i figured out the calculations in my form. However, when I go to export data to excel the fields all say expr 1, expr 2, expr 3 etc... These fields all had names. I think there is some miss communication between my table and queries but I am afraid if I mess with it I will make it worse! Any help you can offer is greatly appreciated!

I am attaching a copy of my database. The form runs fine, until you export the data, then it converts the fields. This may be a simple fix im just not too sure

 

[JHB]

This is because you haven't specified the table name in the query, (row Table).

Then you also have to change all the columns: An example is given below, (be aware of the [ and ], to place them correct.)

Expr4: ALL_DATA.[Table1.PLT]
To
[Table1].[PLT]

 

[rscott1989]

Thank you so much! I will remember that if there is a next time! All is working well now Thanks again!!!