DBDistricts.accdb

<div>
<div class="content wysiwyg-content">
Dear All,<br />
<br />
I have a table with the below structure. &nbsp;There are 40 districts. &nbsp;I need to somehow insert a new row for each district associated with the date placing 0 values. &nbsp;For example the date 1/01/2004 has three rows of data with districts 1, 2 and 3. &nbsp;The date 1/01/2004 needs to be replicated 37 times for districts 4-40 placing 0 values in Field1. &nbsp;You'll notice the next date requires different districts to be inserted.<br />
<br />
I have no idea how to accompish this. &nbsp;Please provide suggestions or examples.<br />
<br />
Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;District &nbsp; &nbsp; &nbsp;Field1<br />
1/01/2004 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10<br />
1/01/2004 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30<br />
1/01/2004 &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0<br />
2/01/2004 &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10<br />
2/01/2004 &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10<br />
2/01/2004 &nbsp; &nbsp; &nbsp; 13 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10
</div>
</div>


Dear All,

I have a table with the below structure.  There are 40 districts.  I need to somehow insert a new row for each district associated with the date placing 0 values.  For example the date 1/01/2004 has three rows of data with districts 1, 2 and 3.  The date 1/01/2004 needs to be replicated 37 times for districts 4-40 placing 0 values in Field1.  You'll notice the next date requires different districts to be inserted.

I have no idea how to accompish this.  Please provide suggestions or examples.

Date                District      Field1
1/01/2004       1                10
1/01/2004       2                30
1/01/2004       3                0
2/01/2004       11              10
2/01/2004       12              10
2/01/2004       13              10

Query to Fill Table - check if value exists?

Dear All,

I have a table with the below structure.  There are 40 districts.  I need to somehow insert a new row for each district associated with the date placing 0 values.  For example the date 1/01/2004 has three rows of data with districts 1, 2 and 3.  The date 1/01/2004 needs to be replicated 37 times for districts 4-40 placing 0 values in Field1.  You&#39;ll notice the next date requires different districts to be inserted.

I have no idea how to accompish this.  Please provide suggestions or examples.

Date                District      Field1
1/01/2004       1                10
1/01/2004       2                30
1/01/2004       3                0
2/01/2004       11              10
2/01/2004       12              10
2/01/2004       13              10

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.