We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

data not added to main table

asked 2018-07-03 23:13:22 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I finally got my weather database back and working after a round of updates stopped it working.

Anyway, I have added 6 months of calc sheets, at 1 per month, to the tables in base. So I now have a table for Jan2018 upto June2018. Previously the data I entered in a form was added to the main tblWXLeedsdata table, and it was that table which was used by the form. I have created queries for each of the 6 new tables, and I cannot remember how the information was added to the main tblWXLeedsdata table. I want to now use the form to insert or add data, but when I open the form , it has the last date as 1/11/2017. No data for 2018 is in the main tblWXLeedsdata table.


edit retag flag offensive close merge delete


@Avvy65 Please do not post as wiki. It helps no one.

Not understanding why you created separate tables when it seems you wanted all the data in the main table. You can append data to an existing table. Possibly clarify what is being attempted.

Ratslinger gravatar imageRatslinger ( 2018-07-04 03:53:15 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-07-04 15:18:55 +0200

Ratslinger gravatar image


Your comment was attached to the deleted duplicate question:

Sorry, I am unclear as to what you mean. When you say 'Please do not post as wiki as it helps no one.' I didn't know I did post as wiki. Do you mean wikipedia here?

If I read you correctly, you say I don't need new tables for each month, mmm, I thought I did. Ok so if I use 'append data' to the main table which the form uses, then that should do it.

As for wiki this is a check box when asking your question:

image description

You can also see above in your question, in upper right, This post is a wiki. instead of your user information.

Now, so as to be carefully clear, it was NOT stated you didn't need new tables. It WAS stated that it was not understood why you created new tables. There is a difference. Also stated:

Possibly clarify what is being attempted.

So, no, you did not read correctly. You have not explained what is being done clearly enough.

edit flag offensive delete link more

answered 2018-07-05 09:36:01 +0200

Avvy65 gravatar image

Thanks, I see the wiki logo, and didn't realise that I was posting as wiki.

I created new tables by copying the data from the calc sheet and going into the tables section of base, then right clicking and then 'paste'. I then changed the name in the popup box which appeared to the correct name. I.E tblJan2018, etc

I then created queries thinking they could be used to extract or filter data as and when required. I probably still had my MS Acccess head on when I did that. The query name was also changed to reflect what it was. I.E : qryJan2018.

I hope that makes it more clear for you, and as I posted back last night, I have now appeneded the data into the main WXLeedsdata table.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-03 23:13:22 +0200

Seen: 156 times

Last updated: Jul 05 '18