Ok, sorry but the error is common on both platforms and the error should be the same and the way to solve it 🙁

Thank you in advance for your help,

JC

Hi,

It is relevant to the number of columns in the group by?

Thks for your help,

JC

ok,

I already change but have the same error:

SELECT

UNIQUE a.whse_id,

a.ord_id,

b.prod_id,

d.ord_qty*d.unit_ship_cse qty_orig,

b.ckpt_id,

Sum(trunc(b.prod_qty)) qty_final

FROM system:iord a, system:ishd b, archive:stord c, archive:stordd d

WHERE a.dc_id = b.dc_id

AND a.whse_id =...

I do not understand? If remove the line from having run perfectly 🙁

Thks,

JC

Thks a lot.

Work 🙂

Best regards,

JC

Hummm,

Don´t work ask me for parameter m and wh.

🙁

JC

Hi again,

I fix this with this.

CDate(Format(Campo,"dd-mm-yyyy"))

Thks a lot for your help,

Regards,

JC

I appreciate your help but still not running.

:crying:

JC

This is run with a string in VS 2012, the database table is a mdb (access):

Dim SQLStringtempprd123 As String = "SELECT CAST([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE CAST([create_dtim],'dd-mm-yyyy') between '01-09-2016...

ChrisM@Work (1/25/2016)

jcachado (1/25/2016)

The statment is:

SELECT format([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE format([create_dtim],'dd-mm-yyyy') GROUP BY format([create_dtim],'dd-mm-yyyy') order by format([create_dtim],'dd-mm-yyyy') desc

Its run, but i think the DESC dont work because...

Ok,

The statment is:

SELECT format([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE format([create_dtim],'dd-mm-yyyy') GROUP BY format([create_dtim],'dd-mm-yyyy') order by format([create_dtim],'dd-mm-yyyy') desc

Its run, but i think the DESC dont work because is ordering...

My mistake , already run but not accept the CAST.

Thks ,

JC

Hi again,

Already work in this way:

SELECT Format([create_dtim],'dd-mm-yyyy'),COUNT(*) AS tot FROM Back_ickpt_prd1 WHERE Format([create_dtim],'dd-mm-yyyy') GROUP BY Format([create_dtim],'dd-mm-yyyy' order by Format([create_dtim],'dd-mm-yyyy'

But when i put ORDER BY dont run.

What is the error?

Thks a...

But if I want per day will have to remove the between right?

Thks,

JC

What your sugestion to replacing format command?

Thks,

JC