i m trying to create a queries so that i can query the results and add a dummy nos to the 3 digit.
i hope u understand where i am going on.
if we placed all the nos in simple manner
0467
1467
2467
3467
4467
5467
6647
7647
8647
9647
so if the results is 1467, i want the queries to append to...
it is okay as long i can select 3 digit and the dummy be replaced by another a range of nos.
in other words
eg if the nos came out 7612 (1267), the query will be 1x67
when x = 4 or 8 or anyt digit (1467)
i m trying to create a access queries tat extracta list of potential nos that will match the existing nos based on pattern
the pattern are 1->>4-->>7
I am creating this access module based on the local lottery system.
How to add potential nos to list in table but append to columns
2499 ---> 2899 or 2199 or 2466 or 5499
3678 ---> 3675 or ....
1248
0169
0367
0468
1256
1267
1368
3889
4999
5568
6777
0148
0889
1146
1235
1357
1477
1489
4579
4668
4899
How to add potential nos to list in table but append to column in another table?
2499 ---> 2899 or 2199 or 2466 or 5499
3678 ---> 3675 or ....
1248
0169
0367
0468
1256
1267
1368
3889
4999
5568
6777
0148
0889
1146
1235
1357
1477
1489
4579
4668
4899
I wish to add 1 or 4 or 7 or 2 to nos in the posiition
eg
1347 become 1344 or 1341 or
1347 become 1317 or 1377 or
1347 become 1647 or 1947 or
1347 become 4347 or 7347
How to code the query to print a weekly date on a report?
I do not need the code for between beginning date and end date but
Eg date between 060101 - 120101
Date Range - Weekday - Weekday (based on Calendar)
I try using this code to add ON not inl ist event but i was prompt but it is not added to the table that this combo table but the data entry table instead and could not reflect for new records. Please advise when i go wrong.
' Dim 3rdParty As Integer
New3rdParty = MsgBox("3rd Party Not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.