Search results

Sill searching for the answer to my above question.

Beautiful Man, you all are the greatest! Thanks SJ and Ken. Your help is greatly appreciated.

No, it only shows me the categories that have sums, not any with sum of 0

One more question Thank you to all, it is working now. One more question. I have a query with total hours of a department broken down by categories. I put in a time frame and sum the hours together depending on the category. Some of the categories have 0 hours. I want all the categories to...

I have a date field. I have Between [Please enter second begin date] And [Please enter second end date] as my criteria so that the user may enter two dates. But, I want the extreme dates to be included in my data. For Example: If the user enters 1/1/2005 and 1/31/2005, I want the...

Are your decimal numbers in a table? If so, open the table and go into design view, and make Decimal Places, 4.

go back and try it again, and click the down arrow and select 4

I have some parameters set up the user needs to enter information. Is there any way to put a back button on these parameters, so, if the user makes a mistake, he/she can just go back one step. :confused:

I have four different queries, all have hours worked from a specific time period. I want to put those four queries into a single bar chart. Is this possible?

Go into Design View, click on the column that has the values in it, right click, go to Properties, click on Decimal Places, then enter 4. That should do it.

Can I create a chart report using multiple queries instead of just one?

Help Still looking for help on this one. I can print the parameters on a report, but the syntax I used will not work on a chart report.

Still Struggling Here is the thing, my created query is hierarchial and posting the single query probably will not help you much. Does each column of a query have to be filled in, in order for the query to show up?

One down, one to go OK, I have my dates working now, but it is giving me alot of duplicate information. Any suggestions?

Still Struggling For some reason, the query is only taking the last two dates I give it. It seems as though it is ignoring all of the ones before the last one.

How do I print parameters on a chart report? And along with that, is there any way to conert a number date parameter into a string date (ie: input of parameter is: 1-1 and want to convert to January 1) Thanks

I would like to eventually creat a chart report with information I have in a query. My problem is that I cannt get the correct information in my query. I want a user to input three begin and end dates and I want the appropriate information displayed in my query. Please help me figure out how...