Query asking for perameter

[LB79]

Hello,

Im having a problem with a custom field in a query.
My custome field is

CurDate: Now()

which works and inserts the current date into the column as I want it too.
The annoying thing is that it always asks for me to enter perameter in a pop up box. Whatever I enter (or leave blank) I still get the current date. Basically, the only problem is its annoying that it pops up.
Is there a way to stop it?

Thanks

 

[khawar]

use date()

 

[BarryMK]

Post your query code

 

[LB79]

That does the same thing as Now() really.
Swapping to Date() still asks for the Perameter too.

 

[khawar]

Ok then you have to post the Sql

 

[LB79]

SELECT LEGS_OutPO_TBL.STATUS, DB_AGENTLIST.[UN Code], DB_AGENTLIST.Sub_Agent, LEGS_OutPO_TBL.AGENT_CD, LEGS_OutPO_TBL.[PO#], Sum(LEGS_OutPO_TBL.PO_USD) AS SumOfPO_USD, Sum(LEGS_OutPO_TBL.GL_USD) AS SumOfGL_USD, Sum(([PO_USD]-[GL_USD])) AS USD_Var, LEGS_OutPO_TBL.PO_ACTIVITY_DATE, Date() AS CurDate, DateDiff("d",[PO_ACTIVITY_Date],[CurDate]) AS OutDays
FROM LEGS_OutPO_TBL LEFT JOIN DB_AGENTLIST ON LEGS_OutPO_TBL.AGENT_CD = DB_AGENTLIST.[AG Code]
GROUP BY LEGS_OutPO_TBL.STATUS, DB_AGENTLIST.[UN Code], DB_AGENTLIST.Sub_Agent, LEGS_OutPO_TBL.AGENT_CD, LEGS_OutPO_TBL.[PO#], LEGS_OutPO_TBL.PO_ACTIVITY_DATE, Date(), DateDiff("d",[PO_ACTIVITY_Date],[CurDate]);

 

[khawar]

SELECT LEGS_OutPO_TBL.STATUS, DB_AGENTLIST.[UN CODE], DB_AGENTLIST.Sub_Agent, LEGS_OutPO_TBL.AGENT_CD, LEGS_OutPO_TBL.[PO#], Sum(LEGS_OutPO_TBL.PO_USD) AS SumOfPO_USD, Sum(LEGS_OutPO_TBL.GL_USD) AS SumOfGL_USD, Sum(([PO_USD]-[GL_USD])) AS USD_Var, LEGS_OutPO_TBL.PO_ACTIVITY_DATE, Date() AS CurDate, DateDiff("d",[PO_ACTIVITY_Date],Date()) AS OutDays
FROM LEGS_OutPO_TBL LEFT JOIN DB_AGENTLIST ON LEGS_OutPO_TBL.AGENT_CD = DB_AGENTLIST.[AG Code]
GROUP BY LEGS_OutPO_TBL.STATUS, DB_AGENTLIST.[UN CODE], DB_AGENTLIST.Sub_Agent, LEGS_OutPO_TBL.AGENT_CD, LEGS_OutPO_TBL.[PO#], LEGS_OutPO_TBL.PO_ACTIVITY_DATE, Date(), DateDiff("d",[PO_ACTIVITY_Date],Date());

 

[LB79]

Thank you!!
What did you do that made the difference - i can see the SQL is shorter but its Friday afternoon and i cant see what...

 

[MaliciousMike]

he changed any reference to [CurDate] to just Date()

TGIF

~Mike

 

[LB79]

Im still confused with this... I have another query and Ive tried to go through it using the example given... but Im gettnig no joy.
The sql is below. Its from the IIf(IsNull that the problem starts (asking for perameter).
SELECT LEGS_OutPO_TBL.STATUS, DB_AGENTLIST.[UN Code], DB_AGENTLIST.Sub_Agent, LEGS_OutPO_TBL.AGENT_CD, LEGS_OutPO_TBL.[PO#], Sum(LEGS_OutPO_TBL.PO_USD) AS SumOfPO_USD, Sum(LEGS_OutPO_TBL.GL_USD) AS SumOfGL_USD, Sum(([PO_USD]-[GL_USD])) AS USD_Var, LEGS_OutPO_TBL.PO_ACTIVITY_DATE, Date() AS CurDate, DateDiff("d",[PO_ACTIVITY_Date],Date()) AS OutDayPO, DateDiff("d",[GL_ACTIVITY_Date],Date()) AS OutDayGL, IIf(IsNull([OutDayPO]) And Not IsNull([OutDayGL]),[OutDayGL],[OutDayPO])+IIf(IsNull([OutDayGL]) And Not IsNull([OutDayPO]),[OutDayPO],[OutDayGL])-IIf(IsNull([OutDayGL]) And Not IsNull([OutDayPO]),[OutDayPO],[OutDayGL]) AS Days
FROM LEGS_OutPO_TBL LEFT JOIN DB_AGENTLIST ON LEGS_OutPO_TBL.AGENT_CD = DB_AGENTLIST.[AG Code]
GROUP BY LEGS_OutPO_TBL.STATUS, DB_AGENTLIST.[UN Code], DB_AGENTLIST.Sub_Agent, LEGS_OutPO_TBL.AGENT_CD, LEGS_OutPO_TBL.[PO#], LEGS_OutPO_TBL.PO_ACTIVITY_DATE, Date(), DateDiff("d",[PO_ACTIVITY_Date],Date()), DateDiff("d",[GL_ACTIVITY_Date],Date()), IIf(IsNull([OutDayPO]) And Not IsNull([OutDayGL]),[OutDayGL],[OutDayPO])+IIf(IsNull([OutDayGL]) And Not IsNull([OutDayPO]),[OutDayPO],[OutDayGL])-IIf(IsNull([OutDayGL]) And Not IsNull([OutDayPO]),[OutDayPO],[OutDayGL]);

Please note i used the + function then had to deduct it because I could see what else I could put in - If you can help with that then that would also be great.

Thanks so much!