Search results

Out of office Hi everyone, I've been out of the office lately. I've tried some different approaches but I keep getting the same results. Does anyone else have any ideas? Thanks.

Here is the simplified db; I hope this will make sense.

Hello, I have created two tables, a student table with all of their personnel information with the student ID as the PK and a course table with the following fields: Student ID Course Title Course Date Score CEU PDU Notes Type (professional development or technical) I have created a student...

Oh happy day... I see that I have much to learn from you! Thank you so much.

I see where you made the changes and its awesome. On the report titled "LMS_Student_Table" how can I get it to add the totals from the two subreports? I tried to mirror what you did, but I may be missing a step. If you have a free minute, can you help me out again? Thanks,

Hmmm. I think I know what you are talking about. I selected the text box that houses subreport1 and then clicked on the properties button to find the source name. Would that be the same? I have a slimmed down version of the database that I could send to you, it is to big to post here. (1.3...

Confused.. what is 'YourSubForm1CONTAINERNameHere'? Where do i find that?

This would be a piece of cake if it was excel, but I just not sure of the proper language to get what I want. I have one report that has two subreports embedded. Each subreport has a subtotal, I need to add those to get a grand total for the report. I need subreport1 total (7.5) to be added...

Thank you!!! I tried both and they worked perfectly, Thank you.

What I am trying to figure out is how to sum a field/column based on the answer from another field/column. Specifically, I have a yes/no field with numeric values in the next field. I want to sum the values of only the fields that are associated with yes. My current formula sums all values...

I added a query to find out who has and has not attended FISH. I would to know the number of those who plan on attending FISH. I added to the screen capture; I hope that is what you were asking.

Sorry. I will do that next time. Thank you for the reply.

I tried that. Here are some screen captures of what I have. On the query, I enter 0 for a No and I have to enter a -1 for a yes. Is that normal?

Is there a way to attach a wav file or mp3 file to a command button?

I tried both of those commands and I still got the #Error script. I can eamil the database if anyone wants to look at it. Any more suggestions?

Is it possible to add a sum comman to a yes/no column? I also changed the column in the table to a number using 0 as no and 1 as yes. When I added =Sum([Attending FISH]) all I got was #Error in the report view. Am I stupid? Well, yeah; but can anyone help me?

On my database, for startup, I had the toolbars taken away from the user. Is there a quick shortcut to pull them back up? I noticed that the 'Tools' option is gone. Thanks.

Overlooked the answer Thanks Bat17, I must've overlooked the brackets around the start and end from your post. I tried it like you suggested and it works.

This works, but not what I need If I remove the [Enter Date:] and replace with "between 8/1/2005 and 12/31/2005" then the query will work. The problem is, when I link this to report, I want the user to be prompted to "Enter Date:" without having to change the design of the query. Is this...

Still same error... Whenever I do that (Between 8/1/05 And 12/31/05), I still receive the same message. Here is what the error says: "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try...