Continously exporting data

[equilib]

Hi,
I'm relatively new at this so I appreciate all help.

Question 1
I have a table (table1) full of data. I want to export part of this data into a new table (table2). The conditions for the data to be exported is that A or B are true and that C or D are true (simple checkboxes). I tried to model this as two queries, one for A or B and one for C or D. But when I tried to combine them into the selection variable, that both conditions have to hold (I made a new queary where I used the previous two queries Q1 and Q2 and set their criteria as "True") Access replied that I can't specify criteria’s for queries. What should I do?

Question 2
I will add more data on the posts exported to table2 via a form. However, table1 is growing continuously and thus the export query will need to be executed every time I open table2 (or the form). How will the additional information previously entered via the form be treated, will it remain or will it be deleted when the export query is run?

Best,
Petter

 

[dcb]

You are moving data from one table to another (if I understand what you are saying) ----- Why?

 

[equilib]

Because I have a lot of data that I will not work with. Thus I want a clean start with only the observations I'm interested in - it helps for visibility and to get an overview of the material.

 

[dcb]

Bit to complicated to explain - I am making a quick example
question
do you want to delete data from table one after export or leave it there?

 

[boblarson]

Because I have a lot of data that I will not work with. Thus I want a clean start with only the observations I'm interested in - it helps for visibility and to get an overview of the material.

Why not just use a query to pull what you want? No other tables needed. In fact, that is one of the powerful things about a relational database. Moving data about is not efficient and can cause database bloat.

 

[equilib]

Great! - Thanks a lot.
No - I want to keep the data in table1 - it is the raw dataset which should not be altered, but will continously grow with more obs.

 

[equilib]

I want to have the raw data in a unique table as it is external data without any manipulation. I would like to separate it in a clear manner from the observations that I pull out - for which additional information will be inserted.

However, the selection queary should look the same in both cases (and I don't know how to write it). Just that I prefer a "make queary".

 

[dcb]

Have a look at this - I often use the basic maths method to analyze this type of scenario - however Bob (having seen some of his other posts) may have a much better way of doing this.

Normally I would do this all in code - have used the queries to give you a method of how to analyze it.

Query1 - The Maths
Query2 - The Filters

 

[equilib]

Thanks a lot - I'll dig into the code right away

 

[dcb]

Thanks a lot - I'll dig into the code right away

Havent done much - Just tried to give you a starting point