Counting problems

tytlwkltc

Registered User.
Local time
Tomorrow, 00:25
Joined
Jun 26, 2014
Messages
29
i have a table like this.

no. times
---------------------
2001 3
2002 1
2003 2

how i can run a query/vba so that it can turn into

200100
200101
200102
200200
200300
200301
 
First, why? I can get you there but its going to take some trickery because you essentially want to create records in your query that don't exist in your underlying table. The corresponding record for:

200300

Isn't in your table, so why are you looking for it to be in your query? What's the purpose of this query? Also, post your actual table and field names.
 
Try the attached database.
 

Attachments

Users who are viewing this thread

Back
Top Bottom