Search results for query: *

Hi All, Im trying to create a crosstab query with parameter entry from a form. I wish to be able to specify a date (using Microsoft DTPicker control) and a shift (using a combo box to the relevant table) to make the selections. These two selections on the form are the criteria for the cross...

Hi there, thanks for responding, im still very novice at this, so i wasn't sure where to put the DateValue function This is what my SQL for the query looked like beforehand: PARAMETERS [Forms]![frmChooseDTDate]![DateOccured] DateTime; SELECT Downtimes.DateOccured, Downtimes.ShiftID...

Hi all, I need to remove the time input from the DTPicker. i am using it as part of a data entry form and added it sometime after i created the form. However, i now find that for any entries which were made using the DTPicker, the queries I run on the entered data does not pick up the entries...

never mind all, i feel really duh right now. so i created the chart and once its on the form, i then right click and wah laaa! there it is, i can select the chart type and its got all this charty goodness available to me. thanks anyway all! regards Keji

Hi all, I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object. I'd do that except I'm trying to create a chart based on a query. Is there a way to make the chart wizard use...