Search results

Thanks for the suggestions, I'll see which works best for me.

I'm trying to add some elements to a report that I figure need to be populated with code, but when I tried to do this I started getting errors about my report having incompatible elements and it wouldn't let me save. This continued even after I deleted what I assumed were the offending elements...

Thank you very much. For some reason it's quite difficult to find documentation of that.

Can someone give me an example of how the "Where" option in a totals query is used? Am I just supposed to choose "Where" and then fill in the criteria line with the appropriate criteria? Or is that separate from how the "Where" option works.

Yeah, I don't have 2003 available on my computer, but I can try having them open it in design view, thanks.

I've created a database in Access 2010, but some of the users still have Access 2003. Every other part of the database seems to work properly. There are forms that the users can navigate to enter records and those work fine. The report in question is fairly simple and is just based on a query...

I really feel like starting a new thread, because I feel like if no one knows how to answer my question, it must be because I'm just terrible at explaining it and all of the stuff above is just going to be unnecessary baggage for getting to the core of the issue. I'll try explaining it from...

I had Expression, but I understand why it won't work. I tried changing it to sum and I got the error "Subqueries cannot be used in the expression Round([NumProduced]/([TimeSpent]/60),0)"

Sorry, not sure what is meant by that. Do you mean the expressions that are present in the calculated fields? The time spent field is Round([StopTime]-[StartTime])*1440,0) And the hourly rate field is Round([NumProduced]/([TimeSpent]/60),0)

Those fields are calculated fields with the simple expressions I described. One is calculates the time elapsed and the other calculates the hourly rate. What I want to happen is for the other fields, which are static and come from the table, to get grouped together and for the calculated...

Thanks, that looks like it will help.

Access newbie here... I have a form where the user must select an option from combo box. On some of these options, I want a comment text field to appear which must be filled out by the user. In preparation for this, I added a yes/no field to the table where the options are stored for...

Oh, the names of the fields are actually ProductionDate and FunctionName, but thanks for the warning on that. The query I've tried has a place for all the fields that the table I described has. It then has 2 calculated fields. One uses the start time and stop time to calculate the minutes...

I'm extremely new to Access, so if you need clarification on something I'd be happy to do that. I'm still learning the lingo. I have a table with the following fields: -ID number -Function -Date -Start Time -Stop Time -Number Processed I want to create a query that will calculate the hourly...