Sql Over Function Syntax?

[DataCobalt]

Good morning all,

 

I am currently trying to build a tabular report that will display a certain field from multiple entries next to one another.

 

Now I know how to select the top record and sorting by a certain field to be able to get one. But I am trying to select from a specific entry so that the table would display each appointment time, in order, in one row.

 

Here is what I have:

Select  EstimatedAppDateTime

OVER 
(Order By EstimatedAppDateTime desc ROWS between 1 and 1 )

Where Job_RID= target.[@field:MM_Job_Record_ID] AND Location_Not_Used_DateTime is null 

This returns the error that the syntax of the OVER function is incorrect.

 

Any ideas?

 

Alternatively, if you have another way to easily display the records in one row I would be very appreciative.

 

Thanks in advance!

 

 

 

[Jan]

Hello DataCobalt,

 

As far as I know, the SELECT in a Calculated field can return only one value. If more than one value is returned, the "Error in formula" will be displayed.

 

Maybe you can use Grouping?

I apologize if the question is silly, I am not sure that clearly understand your goal.

[DataCobalt]

Hello DataCobalt,

 

As far as I know, the SELECT in a Calculated field can return only one value. If more than one value is returned, the "Error in formula" will be displayed.

 

Maybe you can use Grouping?

I apologize if the question is silly, I am not sure that clearly understand your goal.

 

 

No problem Jan,

 

It absolutely would return that error but I plan on restricting it to one row at a time.

 

I just want to be able to select exactly WHICH row it pulls information from based on my sorting.