Query problem

[mikekal]

I have a query that accept this:
<=[frmRptDialogSingle]![enddate] and not this:
=[frmRptDialogSingle]![enddate] in criteria

 

[theDBguy]

Try taking out the "=". I think it's implied.

 

[mikekal]

II tryed but same problem

 

[theDBguy]

II tryed but same problem

Can you please post the complete SQL statement for your query? Also, are making sure the form is open when you run the query?

 

[mikekal]

SELECT [Inventory Transactions].ΑΑ_ΧΡΕΩΣΗΣ, [Inventory Transactions].[Transaction Item], [Inventory Transactions].Quantity, [Inventory Transactions].[Unit Cost], [Inventory Transactions].[Created Date], [Inventory Transactions].ΑΡΤΙΜΟΛΟΓΙΟΥ, [Inventory Transactions].ΠΟΣΟΛΟΓΡΑΦΟΣ, [Inventory Transactions].ΑΑ_ΠΙΣΤΩΣΗΣ, [Inventory Transactions].[Transaction Type], Inventory.Supplier
FROM Inventory INNER JOIN [Inventory Transactions] ON Inventory.ID = [Inventory Transactions].[Transaction Item]
WHERE ((([Inventory Transactions].[Transaction Type])=1) AND (([Inventory Transactions].[Created Date])=[frmRptDialogSingle]![enddate]))
GROUP BY [Inventory Transactions].ΑΑ_ΧΡΕΩΣΗΣ, [Inventory Transactions].[Transaction Item], [Inventory Transactions].Quantity, [Inventory Transactions].[Unit Cost], [Inventory Transactions].[Created Date], [Inventory Transactions].ΑΡΤΙΜΟΛΟΓΙΟΥ, [Inventory Transactions].ΠΟΣΟΛΟΓΡΑΦΟΣ, [Inventory Transactions].ΑΑ_ΠΙΣΤΩΣΗΣ, [Inventory Transactions].[Transaction Type];

 

[theDBguy]

SELECT [Inventory Transactions].ΑΑ_ΧΡΕΩΣΗΣ, [Inventory Transactions].[Transaction Item], [Inventory Transactions].Quantity, [Inventory Transactions].[Unit Cost], [Inventory Transactions].[Created Date], [Inventory Transactions].ΑΡΤΙΜΟΛΟΓΙΟΥ, [Inventory Transactions].ΠΟΣΟΛΟΓΡΑΦΟΣ, [Inventory Transactions].ΑΑ_ΠΙΣΤΩΣΗΣ, [Inventory Transactions].[Transaction Type], Inventory.Supplier
FROM Inventory INNER JOIN [Inventory Transactions] ON Inventory.ID = [Inventory Transactions].[Transaction Item]
WHERE ((([Inventory Transactions].[Transaction Type])=1) AND (([Inventory Transactions].[Created Date])=[frmRptDialogSingle]![enddate]))
GROUP BY [Inventory Transactions].ΑΑ_ΧΡΕΩΣΗΣ, [Inventory Transactions].[Transaction Item], [Inventory Transactions].Quantity, [Inventory Transactions].[Unit Cost], [Inventory Transactions].[Created Date], [Inventory Transactions].ΑΡΤΙΜΟΛΟΓΙΟΥ, [Inventory Transactions].ΠΟΣΟΛΟΓΡΑΦΟΣ, [Inventory Transactions].ΑΑ_ΠΙΣΤΩΣΗΣ, [Inventory Transactions].[Transaction Type];

Try adding this little change...

... AND (([Inventory Transactions].[Created Date])=CDate([frmRptDialogSingle]![enddate])))...

 

[mikekal]

Im sorry do nothing.The same problem

 

[theDBguy]

Im sorry do nothing.The same problem

No error message?

 

[mikekal]

No error.Just show nothing.But if i make it <= its ok.But i want records in specific day.Im sorry for bad english

 

[theDBguy]

No error.Just show nothing.But if i make it <= its ok.But i want records in specific day.Im sorry for bad english

Ah, that tells me you have time components in your data. Is that correct? If so, you'll have to either account for them or remove them.

 

[LarryE]

[frmRptDialogSingle]![enddate]
should be:
[Forms]![frmRptDialogSingle]![enddate]

 

[mikekal]

Im sorry nothing again

 

[mikekal]

Only accept < =

 

[theDBguy]

Only accept < =

Did you see my post? Can you verify if you have time values with your dates?

 

[Minty]

Change this
(([Inventory Transactions].[Created Date])=[frmRptDialogSingle]![enddate]))
to
((DateValue([Inventory Transactions].[Created Date])=[frmRptDialogSingle]![enddate]))

 

[mikekal]

I found that and working :Like "*" & [Forms]![frmRptDialogSingle]![enddate] & "*" Or Is Null

 

[SHANEMAC51]

У меня есть запрос, который принимает это:

SELECT IT.ΑΑ_ΧΡΕΩΣΗΣ,  IT.[Transaction Item],  IT.Quantity,
 IT.[Unit Cost],  IT.[Created Date],  IT.ΑΡΤΙΜΟΛΟΓΙΟΥ,
 IT.ΠΟΣΟΛΟΓΡΑΦΟΣ,  IT.ΑΑ_ΠΙΣΤΩΣΗΣ,  IT.[Transaction Type],
 Inventory.Supplier

FROM Inventory
 INNER JOIN [Inventory Transactions] IT
 ON Inventory.ID = IT.[Transaction Item]
WHERE (((IT.[Transaction Type])=1)
AND ((IT.[Created Date])= FORMAT([frmRptDialogSingle]![enddate],"\#MM\/DD\/YYYY\#)))

GROUP BY IT.ΑΑ_ΧΡΕΩΣΗΣ, IT.[Transaction Item], IT.Quantity,
 IT.[Unit Cost], IT.[Created Date], IT.ΑΡΤΙΜΟΛΟΓΙΟΥ,
 IT.ΠΟΣΟΛΟΓΡΑΦΟΣ, IT.ΑΑ_ΠΙΣΤΩΣΗΣ, IT.[Transaction Type];