troubleshooting Question

Query to Fill Table - check if value exists?

Avatar of AndyC1000
AndyC1000 asked on
Microsoft Access
1 Comment1 Solution224 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros