Last day

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I've go a huge table with a date and value field. I would like to create a
query which returns only the value of the last day per month.

E.G. See below the result of this query and the data:

Query result:
31.01.2005 1142.35
28.02.2005 1176.7
31.03.2005 1151.28
29.04.2005 1123.64


Table values:
Date Value
04.01.2005 1161.53
05.01.2005 1148.83
06.01.2005 1142.25
07.01.2005 1142.08
10.01.2005 1144.14
11.01.2005 1141.11
12.01.2005 1145.9
13.01.2005 1138.8
14.01.2005 1141.07
17.01.2005 1143.16
18.01.2005 1146.44
19.01.2005 1141.45
20.01.2005 1130.98
21.01.2005 1128.21
24.01.2005 1128.37
25.01.2005 1128.65
26.01.2005 1137.96
27.01.2005 1137.93
28.01.2005 1133.39
31.01.2005 1142.35
01.02.2005 1147.97
02.02.2005 1152.68
03.02.2005 1147.03
04.02.2005 1157.96
07.02.2005 1156.22
08.02.2005 1154.02
09.02.2005 1149.07
10.02.2005 1156.06
11.02.2005 1163.29
14.02.2005 1168.61
15.02.2005 1172.31
16.02.2005 1169.64
17.02.2005 1167.52
18.02.2005 1169.15
21.02.2005 1169.35
22.02.2005 1162.93
23.02.2005 1160.73
24.02.2005 1165.42
25.02.2005 1177.13
28.02.2005 1176.7
01.03.2005 1179.96
02.03.2005 1177.94
03.03.2005 1178.78
04.03.2005 1192.42
07.03.2005 1192.3
08.03.2005 1193
09.03.2005 1185.56
10.03.2005 1183.33
11.03.2005 1181.57
14.03.2005 1180.79
15.03.2005 1178.01
16.03.2005 1172.15
17.03.2005 1170.85
18.03.2005 1169.19
21.03.2005 1162.07
22.03.2005 1157.41
23.03.2005 1147.59
24.03.2005 1146.42
25.03.2005 1146.94
28.03.2005 1145.72
30.03.2005 1148.44
31.03.2005 1151.28
01.04.2005 1148.26
04.04.2005 1142.55
05.04.2005 1149.26
06.04.2005 1152.76
07.04.2005 1159.65
08.04.2005 1153.75
11.04.2005 1155.67
12.04.2005 1154.17
13.04.2005 1149.46
14.04.2005 1137.5
15.04.2005 1123.91
18.04.2005 1117.1
19.04.2005 1126.56
20.04.2005 1118.58
21.04.2005 1129.81
22.04.2005 1129.85
25.04.2005 1134.12
26.04.2005 1126.46
27.04.2005 1123.71
28.04.2005 1114.97
29.04.2005 1123.64
02.05.2005 1125.76
03.05.2005 1127.67


Thank you very much for your help.

Kind regards,

Simon
.

Relevant Pages

  • Re: creating Access table from directory with files
    ... Can this be automated or what can be done with VBA? ... Create an Append query that appends data from the linked table to ... The first time you run the query, it will import all the records from ... Kind regards, Surya H. ...
    (microsoft.public.access.externaldata)
  • Re: creating Access table from directory with files
    ... Can this be automated or what can be done with VBA? ... Create an Append query that appends data from the linked table to ... The first time you run the query, it will import all the records from ... Kind regards, Surya H. ...
    (microsoft.public.access.externaldata)
  • Re: Extract data from Oracle
    ... with kind regards ... I just copied the SQL from my MS Query that works ... debug.print your SQL and try running it in your favorite ... the connection string is done before all this. ...
    (microsoft.public.excel.programming)
  • Re: Check if data already exists in database.
    ... Kind regards, Stefan van der Hooft. ... you can create a query, based on T_OE_Ideas, where all fields has criteria ... Is a check if the data is already in the database, ... confirmation. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How do I get a query to show all values when a combo control i
    ... Mine is a GROUP BY query so I assume that the error is linked to trying to ... Kind Regards ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.queries)