473,394 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

How to loop columns in many tables but is same structure

1
Hi, I am doing a project that using microsoft access as database and link to VB.net. I have 3 tables named table1, table2 and table3 with same columns name but different value. For example, let say the table1 have device, week1, week2 and week3 as column, the another 2 tables's structure also same like table1. what i need to do is multiple the week1 value in table1 with week1 value in table2 and display it at table3's week1. the problem i am facing now is the VB.net cannot loop the week from week1 to week3. what i now can do is just select 1 week and calculate from that week... i need some code that can loop the column from week1 to week3 without select and can stop until the last column. this is because in the future maybe have more than 3 week need to calculate.
Anyone got ideal how to do so? thanks!
Sep 20 '10 #1
0 788

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Good Man | last post by:
Hi there I'm in the planning stages of creating a database, and I have two options here. Which makes more sense, and/or provides better performance for queries - a single table with hundreds of...
5
by: oNLINE bUDDY | last post by:
How can you reverse a many-to-many XML structure between 2 tags? Lets say we have a books/author XML file. A book can have many authors. <book1> <Author1> </Author1> </book1>
1
by: narayana | last post by:
how to know about how many tables i created in that database.if the database is connected to many users. i want the query in this way that i want creater,number of tables,time,updates . the...
4
by: Dirk Olbertz | last post by:
Hi there, I'm currently about to redesign a database which you could compare with a database for managing a library. Now this solution will not only manage one library, but 100 to 500 of them....
7
by: Emin | last post by:
Dear experts, If I have a number of related groups of data (e.g., stock prices for different stocks) is it better to put them into many tables (e.g., one table per stock) or into one big table...
1
by: mcasaurabhsumit | last post by:
hello friend, how many tables a dataset can store at a time? can u tell me.
9
by: Ots | last post by:
I'm using SQL 2000, which is integrated with a VB.NET 2003 app. I have an Audit trigger that logs changes to tables. I want to apply this trigger to many different tables. It's the same trigger,...
1
by: zoro25 | last post by:
Hi, Maybe my question is dumb, but I'm not sure what is the best approach. I need to build a report and the data is stored in many tables and queries (8 or 9) and I'm wondering if I should build...
5
by: davec4 | last post by:
I am a new Access use and need to concatenate (UNION) many tables. I am currently doing it "by hand": SELECT * FROM UNION SELECT * FROM ; UNION SELECT * FROM ; ..... UNION SELECT * FROM...
2
TheServant
by: TheServant | last post by:
Hi everybody, I posted a similar question about 6~12 months ago with no definate answer, so I will give it another go, as the choice has popped up again in my programming life: If the number of...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.