Getting date from form causes error?

[CaliburBlade138]

Morning all,

I have a problem where access is getting an error pulling a date from a form. Seems like everything is ok from what I can see, where it's pulling from the table it has the date and time e.g. 3/15/2022 5:35AM, but I just want to pull the date...... any thoughts?

Attachment 47540
Attachment 47541
Attachment 47542
Here is the code:

PARAMETERS [Forms]![formChartByName]![Combo1] Text ( 255 ), [Forms]![formChartByName]![Text3] DateTime;
TRANSFORM Count(*) AS [Count]
SELECT tablemyTimeKeeper.myName
FROM tablemyTimeKeeper
WHERE (((tablemyTimeKeeper.myName)=[Forms]![formChartByName]![Combo1]) AND ((tablemyTimeKeeper.myDateTime)=[Forms]![formChartByName]![Text3]))
GROUP BY tablemyTimeKeeper.myName
PIVOT IIf(InStr([myBarcode],"Indirect")>0,"Indirect","Order");

[Welshgasman]

Use DateValue() on the field ?

[Micron]

What data types are in the controls? I see no delimiters, so only numbers would be appropriate? Strings would have to be delimited with ' , dates with #
e.g.
tablemyTimeKeeper.myName) = '" & [Forms]![formChartByName]![Combo1]) & "' AND...

As written, you're literally passing "[Forms]![formChartByName]![Combo1]" - not what the control contains. Unless I'm wrong and setting the parameter would over-ride that. I'd be surprised if that were the case.

[CaliburBlade138]

Hey,

@Welsh - I tried that and it returns a blank query
@Micron - The date is a textbox set as short date, the combo box I set to Bound Column 1 in properties...

[Welshgasman]

Well I would start simple, get the source data working first, THEN start with PIVOT etc.

Failing that, upload the DB with enough to be able to replicate the problem.

[Micron]

Then try date delimiters instead of text? I agree - to be sure it's not the pivot part that's at fault, just get the select part working from SELECT to WHERE.
Is that sql in a code procedure or a stored query? I'm guessing query because that's the forum you posted in. So, if you try to switch from sql view to datasheet view and it balks, does Access highlight in sql view what it thinks is the offending part?

[CaliburBlade138]

Hey all,

@Welsh - Yeah I am trying everything to my knowledge and your suggestions, very wild how this is acting.
@Micron - It's a query, even trying switching views results in same error.