Table Layout And Queries

[Steveo]

I have a table that contains more information than I need for my database.
This is information I import daily and can not alter that. I have the fields
assigned a primary ID#. I have certain rows of data that I do not want/need
in the table. Is there a way to do a query that will omit the lines not
columns of data in my sheet?

 

[John W. Vinson]

I have a table that contains more information than I need for my database.
This is information I import daily and can not alter that. I have the fields
assigned a primary ID#. I have certain rows of data that I do not want/need
in the table. Is there a way to do a query that will omit the lines not
columns of data in my sheet?

Certainly; you can apply criteria to any field. You don't say how you
determine which rows you want or don't want so obviously we can't tell you
what the criteria would be.

You have (at least) three choices: use criteria on the Append query you use to
do the import to only import the records you want; you can use a Delete query
afterward to permanently remove those records from the imported table; or you
can simply use a select query to select only a subset of the records.

John W. Vinson [MVP]

 

[Steveo]

Ok. Let me make this simple.

This data is imported on a daily basis and changes meaning some rows may be
1 or 2 off however I know what lines I dont want.

In my table I have 14 columns that are always going to be the same, the rows
will vary on a daily basisy.

Ideally I would like to have a table that will display only the rows of data
I opt to have and not display the id.

What I am doing daily is pulling data from a website so I am not sure if
there is an easier way than using excel to do a data web query, this is
currently how I import the data to access.

What is the best way to do this, any examples/suggestions would be greatly
appreciated.

 

[Chris2]

Ok. Let me make this simple.

This data is imported on a daily basis
Check.

and changes meaning

Changes what meaning in what way?

some rows may be 1 or 2 off

What rows may be 1 or 2 rows off of what?

however I know what lines I dont want.

We don't.

What is the best way to do this, any examples/suggestions would be greatly
appreciated.

The best way would be to:

1 -- Provide the relevant portion of your table structure, including keys and indexes.

2 -- Provide some relevant sample data for the table.

3 -- Tell us what your criteria are (what is the basis for excluding some rows).

4 -- Provide some relevant sample desired results.


Sincerley,

Chris O.

 

[John W. Vinson]

We don't.

Exactly!

Thanks, Chris. Awaiting some *useful* input from Steveo.

John W. Vinson [MVP]

 

[Klatuu]

Chrs's post looks like you wrote it, John

 

[John W. Vinson]

Chrs's post looks like you wrote it, John
--

Great minds... <g>

John W. Vinson [MVP]