1

Topic: R6 Report St11 - Survey Summary Report

Can a column be added to this??  - Date survey created in R6......I need to be able to find Surveys added after a certain date

Any help on this would be appreciated

Bob
Doncaster LRC

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

2

Re: R6 Report St11 - Survey Summary Report

Anyone any thoughts on my request regarding an extra column in St11   ??

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

3

Re: R6 Report St11 - Survey Summary Report

Adding S.entry_date to the list of fields (and a comma after S.NE_Long) should do what you want ie

    S.NE_Lat, 
    S.NE_Long,
    S.Entry_date
INTO #TempFields
FROM Survey S
Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

4

Re: R6 Report St11 - Survey Summary Report

Thanks Charlie - I'll have a go at that and get back to you
Bob

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

5

Re: R6 Report St11 - Survey Summary Report

How do I edit an xml document. JNCC_St11_Survey Summary is in xml format. I tried to open the xml document in notepad but got a message that I "need an app" to edit the document. What's that about?

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

6

Re: R6 Report St11 - Survey Summary Report

Right click -> Open with works for me. Otherwise, using File -> Open from within Notepad should work

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

7

Re: R6 Report St11 - Survey Summary Report

Done that now - got a modified file in Notepad - how do you get it back into xml format?

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

8

Re: R6 Report St11 - Survey Summary Report

Went onto web and got solution as to what to type in Save As......now works a treat - thanks Charlie
Bob

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU