Queries criteria using an integer as the output

[cariene]

I have information like so

ID# Field1

1 Cariene Jawors
2 123 Sesame St
3 Tampa, fl 33634
4 [e-mail]
5
6 John Doe
7 123 Big Bird Row
8 Tampa, FL 33634
9 [e-mail]

ect.


It is in rows excatly as above. All my other db info is in columns. I need to change the information to column entrys.

I have been trying to write a query that calls for every 5th id# starting with id #1. I am quite lost as how to write and retrieve the info.
Any help would be greatly apprieciated.

[Rabbit]

This is definitely the wrong way to store data.

If you are certain that the entire dataset is in this format then you can use the mod operator to bring the information into columns.

ID# mod 5 = 1 is the first line of information
ID# mod 5 = 2 is the second line of information
and so on.

[mlcampeau]

I have information like so

ID# Field1

1 Cariene Jawors
2 123 Sesame St
3 Tampa, fl 33634
4 [e-mail]
5
6 John Doe
7 123 Big Bird Row
8 Tampa, FL 33634
9 [e-mail]

ect.


It is in rows excatly as above. All my other db info is in columns. I need to change the information to column entrys.

I have been trying to write a query that calls for every 5th id# starting with id #1. I am quite lost as how to write and retrieve the info.
Any help would be greatly apprieciated.

Instead of having a new row for the name, address, and email address you should have your table set up with the following fields:

ID#; Last Name; First Name; Address; City; State; ZipCode; Email

so your output would look like:

1; Jawors; Cariene; 123 Sesame St; Tampa; FL; 33634; [e-mail]
2; Doe; John; 123 Big Bird Row; Tampa; FL; 33634; [e-mail]

This setup will make your life waaaaaaaay easier!!!

[cariene]

All my other data is set up in colums with headings. This is new data given in this format. I cannot import it untill it is modified.

[cariene]

I have read alot today trying to find all I could on the mod operator. I do simple db work and am not understanding any of the macro information yet. Fourtunatly I do know how to write some sql queries but I could not understand if I should use this mod operator in a simple access query, macros, or SQL view.

When I have tried to use it in access, I cannot. I am getting that i cannot use the asteric, in criteria.

My data has under one field (or row) 655527 entries, so i must changed it numerically. If some one could tell me, should I be writing this in an access query or a macro ect. That also would be helpful.

[Rabbit]

1 Cariene Jawors
2 123 Sesame St
3 Tampa, fl 33634
4 [e-mail]
5
6 John Doe
7 123 Big Bird Row
8 Tampa, FL 33634
9 [e-mail]

If this is how your data is set up through and through. Then you can set it up over 5 SQL queries. Using mod to select the correct rows, \ to set up a key, and a join query to connect them all.

[cariene]

Thank you very much. I really appreciate it. Cariene

[Rabbit]

Not a problem, let us know if you have any questions.