Search results

I like the feedback I'm getting so thank you. The problem I've got I guess is that I have a 130K rows a week and no change indicators. So from a Normalisation point of view I suppose I would be better using the weekly files to update 1 master sheet, and only append new additions with a...

Well I actually have weekly directory's that are 130K rows long. What I've set up so far is to query the newest versus the previous to see what's new. Might be 20-30 new rows per week... I was thinking about giving the option to pick the week so you could see changes over a longer period...

Hi, been using access for a little while but only just started using forms. If anyone has a good tutorial they can point me to that would be great. One thing I was wondering was, Is it possible to have an option in forms where you can select the table to be used in a query? same query, but...

Thanks, It is probably going to be ongoing but some of the tables can have a million rows so I'm not sure if I can append them all together, I could probably do that for the smaller data sets but I'm not even loading the data into the database at the moment, I'm just linking the tables, I don't...

Hi I don't know hoe to mark this thread as Solved but just to say the Union query did the job, thanks!

Thanks for the reply, I've not used a union query before but I'll have a play and do some homework on it.

Thanks for the reply. I haven't considered a union query, Its not a query type I ever really use or understand to be honest. It would probably be a regular need to add monthly tables and interrogate the tables for different questions. e.g. pull all the data for one customer out of each of...

Hi, This might be a really basic question, I don't do much in SQL, tend to mainly use the design mode. I get verylarge monthly data tables in which every row has a period identifier e.g. 201705. All the monthly tables are separate.201507, 201506 etc I've linked them into my database. Can a...

Hi, I'm pretty much self taught after being given a job of looking after some databases becauses some people left the company. I kind of need to learn more on the SQL side etc, I tend to work with monthly datasets that are too large for Excel. I am about to ask a question that might be simple...