Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Looking for help with crosstab queries and their relationship to forms
Ok. Thank you very much. I got it to work. I had to add .[value] to the end of the [forms]![frmGetDates_ESS]![dfrom] and [forms]![frmGetDates_ESS]![dto]. so now my SQL looks like this. PARAMETERS [forms]![frmGetDates_ESS]![dfrom].[value] DateTime, [forms]![frmGetDates_ESS]![dto].[value]...- MConlisk
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
Looking for help with crosstab queries and their relationship to forms
Ok, now it will go through with out an error. but I dont get any data. I can run the query without the form open, manually enter the dates in the pop-ups, and the data is there. But if I open the form and type the dates in the text boxes I get no data. Is there anything else I can try.- MConlisk
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Looking for help with crosstab queries and their relationship to forms
I am having a problem using a form to supply dates to a crosstab query. I have a form named "frmGetDates_ESS" and it has two text fields "dfrom" and "dto". Here is the SQL view of my query. PARAMETERS [from] DateTime, [to] DateTime; TRANSFORM Count(dbo_CallLog.ID) AS CountOfID SELECT...- MConlisk
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
