Search results for query: *

Duane, I put the code into my subreport. It does not if me the option to put the dates I want to have on the subreport. The main report and the subreports has different dates. Do I need to put something in the on open of the subreport?

Duane there are dates on a form. In my query for the main Report I have >=[Forms]![Report Date Range]![Beginning Date] And <=[Forms]![Report Date Range]![Ending Date]. In subreport query I have between [Beginning Date] and [Ending Date]. I want to put in dates for both reports. But the subreport...

I have a report that have a subreport. I am using a date range form to pull up the dates in the main report. I want to pull up different dates in my subreport. I know this can be done but I am not sure how. Please help.

Thanks cghoga, but here is the layout of my report. It is running off of a table query. The report looks like this: Name PayrollID Hours Payrate OTHours Jane Doe 22222 40 20 Jane Doe 22222 3.5 11.75 Jane Doe 22222 2 19 I need to...

Hello, we have a report that has mutiple payrates. This also give us overtime hours. There is an entry for each payrate on an employee. Most employees have two payrates. How do I add up the hours for each payrate together to determine the overtime for an employee. And how do I determine the...

I have a table query which I have to update everytime new information is put into the database. The report that comes from this query has two other queries that is needed to actually get my information. I want to click on the report and automatically update call queries before the report opens...

I need a total in my report. I created a text box in the detail section. In the control source I put =IIf([SumOfHours]>40, [SumOfHours]-40,0), this gives me what I need in the detail section. I want to sum the total of that text box. In the group footer I put =Sum([Overtime]). It returns...

CosmoKramer you are a God send. I went back and looked at the SQL. typed something in wrong. Your code works perfectly. Thank you very much and everyone else for their help. You get a star for this one CosmoKramer. I was pulling my hair out. Thanks again. Take care and have a wonderful day.

CosmoKramer, you were right on. My problem is that I need to connect the Client with the Employee. When I try to do that the totals change. Is there a way to connect them without changing my totals? Something to look like this. Jane Doe #21111 (employee) John Doe 19 40

CosmoKramer, everthing is coming together. There is one problem. If the rate have different hours, they do not add together. They only add the hours if the hours are the same. This is an example of what input data: Rate Hours John Doe 19 5 19...

CosmoKramer when I run the main report I get the same number that is in my employee total control.

Scriver, I tried your suggestion. The only thing is it does not total each rate. It gives a list that looks like this: John Doe 19 8 19 8 19 8 20 8 I would like for it to look like this: John Doe 19 24 20 8 Is this...

CosmoKramer I have tried it in the report footer and I get a 0. When I open the subreport by itself it works fine. It is not working when I open the main report. Right now I have the running sum in the group footer.

I have a report that looks like this: Date Client Name Rates Hours Mon, May 26 John Doe 19 5 Tue, May 27 John Doe 17 10 Wed, May 28 John Doe 19 5 Thr, May 29 John Doe 17 10 Fri, May 30 John Doe 19 5 Mon...

I would like to get a running sum in my subreport in the main report. If I view the subreport alone the running sum totals are there. When I view the main report, I do not get the running sum. What is it I am doing wrong? Can anyone help me with this problem?

I am working with a report that deals with hours. I am trying to get overtime hours for a two week period. My hours are calculated daily. I tried using a subform to pull up the second weeks hour , but if there is no data in the main form for a person in the first week then data will not show in...

Thanks Humbleprogrammer. This was easy enough.

wtmcknown hello. My data is stored as daily hours.

I am trying to omit records if a certain field in a report is blank. I am not using a query for this report. The Controlsource consist of various fields from different tables. Is there a way to omit these records?

I have created a time sheet. This time sheet is based on a two week period (80 hours). I need to show overtime hours for the first week based on a forty hour week and overtime hours for the second week based on forty hours. I have a text box giving me hours over forty, but this box is also...