Using Active X Calendar in query

[Broadbonian]

Trying to use a make table query. Would like to use starting date in the
form, then increment by 1, 2 ect..to get Monday-Sat dates. Get "Data type
mismatch in query expression". Can anyone help? Thanks
SELECT Forms!frmDates!startdate AS Sun, Forms!frmDates!startdate+1 AS Mon
INTO test;

 

[Douglas J. Steele]

Not sure whether it'll work, but try

SELECT CDate(Forms!frmDates!startdate) AS Sun,
CDate(Forms!frmDates!startdate)+1 AS Mon INTO test;

Of course, your table isn't normalized, so you might want to reconsider what
you're doing.

 

[Bob Barrows [MVP]]

Trying to use a make table query. Would like to use starting date in
the form, then increment by 1, 2 ect..to get Monday-Sat dates. Get
"Data type mismatch in query expression". Can anyone help? Thanks
SELECT Forms!frmDates!startdate AS Sun, Forms!frmDates!startdate+1 AS
Mon INTO test;

Two things:
1. Be explicit: Forms!frmDates!startdate.value <--

2. You will likely need a PARAMETERS clause to tell Access to apply the
proper datatype to the value from the form control:
PARAMETERS Forms!frmDates!startdate.value DateTime;
SELECT ...

 

[Broadbonian]

That's exactly what I needed. Thank You
--
Darc

Not sure whether it'll work, but try

SELECT CDate(Forms!frmDates!startdate) AS Sun,
CDate(Forms!frmDates!startdate)+1 AS Mon INTO test;

Of course, your table isn't normalized, so you might want to reconsider what
you're doing.

 

[Broadbonian]

Thanks for the prompt response. Both of these work great.