ziedyahiaoui
Messages postés4Date d'inscriptionvendredi 11 mai 2012StatutMembreDernière intervention22 mai 2012
-
11 mai 2012 à 11:47
castours
Messages postés2955Date d'inscriptionlundi 18 septembre 2006StatutMembreDernière intervention31 août 2019
-
12 mai 2012 à 09:33
Bonjour,
Prière de m'aider a fin de trouver une qui sert de supprimer des enregistrements d'une base de donnée access, cette base contient plusieurs tables dont un champ (TimeOfSimple) de type date/heure -voir ci-dessous- qui affiche plusieurs dates de mois différents,mon objectif est comment arriver a supprimer les dates anciens et maintenir seulement les dates de dernier mois, exp Avril 2012.
Index TimeOfSample
0 1/24/2012 11:18:35 AM
1 1/24/2012 11:19:00 AM
66 1/24/2012 4:53:52 PM
167 1/24/2012 10:49:43 PM
212 1/25/2012 12:00:06 AM
273 1/25/2012 6:08:31 AM
321 1/25/2012 8:02:28 AM
433 1/25/2012 4:19:24 PM
436 1/25/2012 4:22:24 PM
438 1/25/2012 4:24:23 PM
524 1/26/2012 7:53:05 AM
592 1/26/2012 4:54:54 PM
686 1/27/2012 12:00:12 AM
785 1/27/2012 9:24:31 AM
851 1/27/2012 2:11:27 PM
859 1/27/2012 2:19:27 PM
879 1/27/2012 2:39:27 PM
891 1/27/2012 2:51:27 PM
962 1/27/2012 4:23:24 PM
1057 1/28/2012 12:00:18 AM
1167 1/28/2012 8:14:08 AM
1222 1/28/2012 4:39:00 PM
1319 1/29/2012 12:00:16 AM
1391 1/29/2012 3:49:43 AM
1414 1/29/2012 7:00:40 AM
1477 1/29/2012 8:12:40 AM
1562 1/29/2012 5:07:28 PM
1641 1/30/2012 9:00:49 AM
1767 1/30/2012 4:27:38 PM
1866 1/31/2012
1896 1/31/2012 12:57:26 AM
2016 1/31/2012 7:00:18 AM
2084 1/31/2012 8:15:18 AM
2136 1/31/2012 4:32:06 PM
2194 2/1/2012 3:17:55 AM
2220 2/1/2012 7:00:50 AM
2258 2/1/2012 7:44:49 AM
2338 2/1/2012 6:19:28 PM
2365 2/1/2012 9:41:21 PM
2371 2/2/2012 12:00:03 AM
2474 2/3/2012 12:00:05 AM
2570 2/4/2012 5:11:45 AM
2698 2/4/2012 7:50:41 AM
2786 2/4/2012 5:03:29 PM
2891 2/5/2012 12:00:07 AM
2909 2/5/2012 12:39:21 AM
3035 2/5/2012 4:20:08 PM
3090 2/5/2012 11:08:59 PM
3141 2/6/2012 12:00:01 AM
3223 2/6/2012 4:54:35 PM
3295 2/6/2012 10:04:26 PM
3385 2/7/2012 11:42:15 AM
3490 2/7/2012 4:12:10 PM
3531 2/7/2012 5:00:10 PM
3609 2/7/2012 9:05:08 PM
3622 2/8/2012 12:00:03 AM
3700 2/8/2012 6:08:42 PM
3718 2/8/2012 9:23:37 PM
3829 2/10/2012
3941 2/11/2012 12:00:06 AM
4063 2/11/2012 5:29:13 AM
4150 2/11/2012 7:01:12 AM
4153 2/11/2012 7:04:12 AM
4240 2/11/2012 9:08:10 AM
4322 2/11/2012 7:28:59 PM
4421 2/12/2012 12:00:54 AM
4526 2/12/2012 5:11:29 PM
4527 2/12/2012 5:12:29 PM
4528 2/12/2012 5:13:29 PM
4611 2/12/2012 10:09:21 PM
4678 2/13/2012 12:00:03 AM
4794 2/14/2012 12:00:01 AM
4911 2/15/2012 12:00:04 AM
4992 2/15/2012 1:30:16 AM
5051 2/15/2012 7:01:07 AM
5053 2/15/2012 7:03:07 AM
5081 2/15/2012 7:31:06 AM
5103 2/15/2012 10:38:23 AM
5104 2/15/2012 10:38:23 AM
5165 2/15/2012 3:00:22 PM
5166 2/15/2012 3:00:22 PM
5219 2/15/2012 4:57:59 PM
5221 2/15/2012 4:59:59 PM
5225 2/15/2012 5:03:59 PM
5330 2/16/2012 7:42:43 AM
5381 2/16/2012 4:08:37 PM
5429 2/16/2012 4:56:36 PM
5432 2/16/2012 4:59:36 PM
5555 2/17/2012 12:00:25 AM
5678 2/17/2012 7:59:18 AM
5689 2/17/2012 8:14:17 AM
5693 2/17/2012 8:18:17 AM
5820 2/17/2012 5:23:04 PM
5945 2/18/2012
6048 2/18/2012 7:37:43 AM
6099 2/18/2012 5:25:39 PM
6225 2/19/2012 12:00:24 AM
6324 2/19/2012 7:32:15 AM
6451 2/19/2012 5:19:58 PM
6524 2/20/2012 12:25:53 AM
6592 2/20/2012 7:00:44 AM
6621 2/20/2012 7:29:44 AM
6744 2/20/2012 5:15:30 PM
6871 2/21/2012 12:00:19 AM
6952 2/21/2012 8:10:09 AM
7061 2/21/2012 4:59:55 PM
7111 2/22/2012 12:00:20 AM
7199 2/22/2012 8:37:38 AM
7201 2/22/2012 8:39:38 AM
7202 2/22/2012 8:40:38 AM
7240 2/22/2012 9:54:37 AM
7256 2/22/2012 10:10:37 AM
7355 2/22/2012 2:23:32 PM
7358 2/22/2012 2:26:32 PM
7363 2/22/2012 4:46:31 PM
7370 2/22/2012 4:53:31 PM
7472 2/22/2012 4:30:31 PM
7475 2/22/2012 4:33:31 PM
7484 2/22/2012 4:42:31 PM
7487 2/22/2012 4:46:31 PM
7494 2/22/2012 4:53:31 PM
7588 2/23/2012 7:23:09 AM
7589 2/23/2012 7:24:09 AM
7590 2/23/2012 7:25:08 AM
7691 2/23/2012 4:49:50 PM
7717 2/23/2012 5:15:48 PM
7719 2/23/2012 5:17:48 PM
7771 2/24/2012 12:00:41 AM
7847 2/24/2012 7:03:33 AM
7909 2/24/2012 5:29:26 PM
7962 2/25/2012 12:00:18 AM
8067 2/25/2012 7:31:14 AM
8072 2/25/2012 7:36:14 AM
8076 2/25/2012 7:40:14 AM
8141 2/25/2012 5:31:04 PM
8196 2/26/2012 12:00:23 AM
8288 2/26/2012 7:16:44 AM
8349 2/26/2012 5:25:35 PM
8405 2/27/2012 12:00:26 AM
8526 2/27/2012 9:04:16 AM
8600 2/27/2012 5:37:03 PM
8691 2/28/2012 7:13:45 AM
8764 2/28/2012 5:35:26 PM
8822 2/29/2012 12:00:18 AM
8914 2/29/2012 7:13:08 AM
8989 2/29/2012 5:35:57 PM
9080 3/1/2012 7:11:38 AM
9158 3/1/2012 5:38:13 PM
9218 3/2/2012 12:00:05 AM
9315 3/2/2012 7:15:58 AM
9396 3/2/2012 5:39:48 PM
9486 3/3/2012 7:08:21 AM
9564 3/3/2012 5:36:05 PM
9626 3/4/2012
9708 3/4/2012 8:18:44 AM
9715 3/4/2012 8:25:44 AM
9729 3/4/2012 8:39:44 AM
9738 3/4/2012 9:12:43 AM
9820 3/4/2012 11:45:40 AM
9894 3/4/2012 5:30:37 PM
9969 3/5/2012 8:11:20 AM
9993 3/5/2012 8:35:19 AM
10002 3/5/2012 8:44:19 AM
10075 3/5/2012 5:29:03 PM
10139 3/6/2012
10232 3/6/2012 7:07:53 AM
10321 3/6/2012 4:23:40 PM
10387 3/7/2012 12:00:01 AM
10439 3/7/2012 7:45:21 AM
10517 3/7/2012 2:51:16 PM
10523 3/7/2012 2:57:16 PM
10551 3/7/2012 4:08:14 PM
10579 3/7/2012 4:36:14 PM
10582 3/7/2012 4:39:14 PM
10678 3/8/2012 7:08:57 AM
10779 3/8/2012 5:53:44 PM
10847 3/9/2012
10951 3/9/2012 7:15:27 AM
11025 3/9/2012 4:05:15 PM
11028 3/9/2012 4:08:15 PM
11052 3/9/2012 4:32:13 PM
11058 3/9/2012 4:38:13 PM
11071 3/9/2012 4:51:13 PM
11140 3/10/2012 12:00:02 AM
11218 3/10/2012 8:07:54 AM
11255 3/10/2012 8:44:53 AM
11266 3/10/2012 8:55:53 AM
11267 3/10/2012 8:56:53 AM
11338 3/11/2012 12:00:01 AM
11460 3/11/2012 7:30:18 AM
11507 3/11/2012 10:30:11 AM
11601 3/12/2012 7:01:46 AM
11705 3/12/2012 5:51:35 PM
11778 3/13/2012 12:00:19 AM
11870 3/13/2012 6:58:20 AM
11971 3/13/2012 5:47:00 PM
12065 3/14/2012 6:59:32 AM
12168 3/14/2012 5:48:16 PM
12243 3/15/2012 12:00:01 AM
12334 3/15/2012 6:54:58 AM
12440 3/15/2012 5:49:40 PM
12496 3/16/2012 4:59:26 AM
12500 3/16/2012 5:03:26 AM
12602 3/16/2012 7:52:23 AM
12714 3/16/2012 5:55:02 PM
12792 3/17/2012 12:00:15 AM
12880 3/17/2012 6:49:39 AM
12885 3/17/2012 6:54:39 AM
12930 3/17/2012 8:13:37 AM
13045 3/17/2012 5:56:18 PM
13124 3/18/2012 12:00:01 AM
13212 3/18/2012 6:47:55 AM
13328 3/18/2012 5:55:36 PM
13416 3/19/2012 6:47:12 AM
13532 3/19/2012 5:54:51 PM
13614 3/20/2012 12:00:03 AM
13713 3/20/2012 6:56:30 AM
13818 3/20/2012 5:42:18 PM
13901 3/21/2012
14013 3/21/2012 7:08:03 AM
14097 3/21/2012 5:19:50 PM
14198 3/22/2012 6:56:36 AM
14250 3/22/2012 4:47:13 PM
14254 3/22/2012 4:51:13 PM
14276 3/22/2012 5:13:13 PM
14361 3/23/2012
14475 3/23/2012 7:07:54 AM
14521 3/23/2012 10:14:23 AM
14522 3/23/2012 10:14:23 AM
14643 3/23/2012 5:52:53 PM
14732 3/24/2012
14848 3/24/2012 7:06:39 AM
14849 3/24/2012 7:07:39 AM
14856 3/24/2012 7:24:39 AM
14858 3/24/2012 7:26:39 AM
14874 3/24/2012 7:42:38 AM
14978 3/24/2012 5:34:26 PM
15080 3/25/2012 6:52:03 AM
15104 3/25/2012 7:16:03 AM
15186 3/25/2012 10:46:56 AM
15279 3/25/2012 6:42:36 PM
15370 3/26/2012 12:00:01 AM
15444 3/26/2012 6:22:10 AM
15538 3/26/2012 6:41:56 PM
15625 3/27/2012 6:34:42 AM
15750 3/27/2012 5:52:28 PM
15843 3/28/2012
15942 3/28/2012 6:45:13 AM
15991 3/28/2012 5:54:58 PM
16086 3/29/2012 12:00:01 AM
16176 3/29/2012 6:34:37 AM
16233 3/29/2012 6:01:18 PM
16356 3/30/2012 7:06:59 AM
16428 3/30/2012 4:55:48 PM
16452 3/30/2012 5:19:47 PM
16457 3/30/2012 5:24:47 PM
16554 3/31/2012 12:00:14 AM
16645 3/31/2012 6:33:27 AM
16705 3/31/2012 6:02:12 PM
16793 4/1/2012 6:29:51 AM
16885 4/1/2012 6:33:35 PM
16956 4/1/2012 11:32:28 PM
16984 4/2/2012 12:00:02 AM
17046 4/3/2012 6:01:55 AM
17086 4/3/2012 7:46:55 AM
17168 4/3/2012 9:01:35 PM
17174 4/4/2012 12:00:08 AM
17210 4/4/2012 3:09:24 AM
17313 4/4/2012 8:16:21 AM
17393 4/4/2012 4:58:14 PM
17475 4/4/2012 11:40:07 PM
17528 4/5/2012 4:30:59 AM
17581 4/5/2012 6:37:56 AM
17684 4/6/2012 12:00:06 AM
17747 4/6/2012 5:59:11 PM
17810 4/6/2012 8:06:07 PM
17898 4/7/2012 2:23:57 AM
17966 4/7/2012 6:18:53 AM
18044 4/7/2012 6:13:40 PM
18149 4/8/2012
18247 4/8/2012 6:32:23 AM
18353 4/9/2012 12:00:01 AM
18438 4/9/2012 3:38:27 PM
18511 4/9/2012 5:33:24 PM
18612 4/9/2012 10:34:13 PM
18673 4/10/2012 12:01:11 AM
18684 4/10/2012 12:12:10 AM
18759 4/10/2012 1:35:07 AM
18885 4/10/2012 3:46:00 AM
18911 4/10/2012 6:20:53 AM
19019 4/11/2012 12:00:09 AM
19144 4/11/2012 2:23:24 AM
19244 4/11/2012 6:31:17 AM
19325 4/11/2012 6:11:57 PM
19407 4/11/2012 11:32:50 PM
19435 4/12/2012 12:00:01 AM
19509 4/12/2012 4:43:43 AM
19563 4/12/2012 6:30:42 AM
19682 4/13/2012 5:28:00 AM
19751 4/13/2012 6:44:59 AM
19752 4/13/2012 6:45:59 AM
19753 4/13/2012 6:46:59 AM
19754 4/13/2012 6:47:59 AM
19755 4/13/2012 6:48:59 AM
19808 4/13/2012 7:48:56 AM
19819 4/13/2012 7:59:56 AM
19820 4/13/2012 8:00:56 AM
19825 4/13/2012 8:05:55 AM
19829 4/13/2012 8:09:55 AM
19830 4/13/2012 8:10:55 AM
19831 4/13/2012 8:11:55 AM
19836 4/13/2012 8:20:55 AM
19961 4/13/2012 6:53:46 PM
20038 4/13/2012 8:12:45 PM
20135 4/14/2012 12:00:01 AM
20136 4/14/2012 12:00:39 AM
20225 4/14/2012 6:16:27 AM
20234 4/14/2012 6:25:27 AM
20252 4/14/2012 6:43:27 AM
20267 4/14/2012 7:09:27 AM
20309 4/14/2012 8:56:26 AM
20425 4/14/2012 6:43:14 PM
20516 4/15/2012 6:18:00 AM
20638 4/15/2012 2:48:44 PM
20752 4/16/2012 12:00:05 AM
20833 4/16/2012 6:06:22 AM
20885 4/16/2012 5:37:04 PM
20968 4/16/2012 11:27:55 PM
21062 4/17/2012 3:53:50 AM
21070 4/17/2012 6:27:47 AM
21195 4/17/2012 4:09:32 PM
21311 4/18/2012 12:00:01 AM
21403 4/18/2012 7:35:03 AM
21497 4/18/2012 6:16:46 PM
21585 4/19/2012 6:10:27 AM
21707 4/19/2012 5:24:07 PM
21825 4/20/2012
21909 4/20/2012 6:04:51 AM
21965 4/20/2012 5:36:33 PM
21975 4/20/2012 5:46:32 PM
21988 4/20/2012 5:59:32 PM
22002 4/20/2012 6:13:32 PM
22005 4/20/2012 6:16:32 PM
22070 4/20/2012 11:05:26 PM
22106 4/21/2012 2:51:21 AM
22222 4/21/2012 6:03:14 AM
22285 4/21/2012 5:42:43 PM
22286 4/21/2012 5:43:43 PM
22287 4/21/2012 5:44:42 PM
22297 4/21/2012 5:54:42 PM
22307 4/21/2012 6:04:42 PM
22314 4/21/2012 9:01:27 PM
22341 4/22/2012
22440 4/22/2012 6:16:28 AM
22445 4/22/2012 6:21:28 AM
22524 4/22/2012 10:11:22 AM
22603 4/22/2012 4:36:09 PM
22628 4/22/2012 5:49:07 PM
22680 4/22/2012 6:41:05 PM
22688 4/22/2012 9:00:02 PM
22717 4/23/2012 12:00:06 AM
22809 4/23/2012 6:07:30 PM
22846 4/23/2012 7:19:30 PM
22896 4/24/2012 4:05:14 AM
22937 4/24/2012 6:03:08 AM
23063 4/25/2012 12:00:01 AM
23166 4/25/2012 6:16:13 PM
23253 4/26/2012 5:59:55 AM
23359 4/26/2012 6:18:39 PM
23367 4/26/2012 8:55:37 PM
23400 4/27/2012
23450 4/27/2012 5:21:30 AM
23486 4/27/2012 5:57:29 AM
23580 4/27/2012 6:05:08 PM
23676 4/27/2012 10:22:03 PM
23758 4/28/2012
23782 4/28/2012 3:15:53 AM
23905 4/28/2012 5:59:49 AM
23956 4/29/2012 12:00:01 AM
24068 4/29/2012 4:59:48 PM
24187 4/29/2012 10:26:37 PM
24215 4/29/2012 11:02:37 PM
24221 4/30/2012 12:00:16 AM
24256 4/30/2012 1:48:33 AM
24370 4/30/2012 6:20:05 PM
24490 4/30/2012 8:33:03 PM
24544 5/1/2012
24617 5/1/2012 6:57:32 PM
24690 5/1/2012 9:04:29 PM
24731 5/2/2012
24773 5/2/2012 1:52:23 AM
24843 5/2/2012 5:48:19 AM
castours
Messages postés2955Date d'inscriptionlundi 18 septembre 2006StatutMembreDernière intervention31 août 2019217 12 mai 2012 à 09:33
Bonnjour
Dans une requete tu extrais les mois et les années du champs date par ceci
MoisExtrait: Format([TimeOfSimple];"mm")
Ce qui va dans le champ MoisExtrait te numeroter les mois.
AnExtrait: Format([TimeOfSimple];"aaaa")
Ce qui va dans le champ AnExtrait te donner l'année
Dans la meme requete tu fais un tri croissant sur le mois et sur l'année
Normalement tu devrais avoir les dates les plus anciennes en haut de ta selection.