Supprimer enregistrements Access de type Date

Fermé
ziedyahiaoui Messages postés 4 Date d'inscription vendredi 11 mai 2012 Statut Membre Dernière intervention 22 mai 2012 - 11 mai 2012 à 11:47
castours Messages postés 2955 Date d'inscription lundi 18 septembre 2006 Statut Membre Dernière intervention 31 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

Meilleures salutation.



A voir également:

1 réponse

castours Messages postés 2955 Date d'inscription lundi 18 septembre 2006 Statut Membre Dernière intervention 31 août 2019 217
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.
0