Search results

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...

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...

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...

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

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.

I am wanting to use a query to find dates within a range, like a quarter. Within the criteria I put "[Enter Date:]". I ran the query and tried the "Between..And.." operator and even "<=9/1/05 and >=12/31/05". All I get is an error message saying incorrect syntax or structure. Any questions...

I have created a form with all the buttons that I need and the have designed it way that I want. I have chosen to have it open upon startup. However, It is not maximized. How can I get it to resize to the windows max? thanks.

Here is what I have so far. Table 1 has employee info. Table 2 is for the courses that employees take. Table 3 is a listing of available training courses. What I have done is created a form with all the employee info and linked it to table 2 by ss #'s. What I am wondering is if I can create...

I have built a table with a field name of Birth date and have applied an input mask to have the data shown as: ##/##/##. Now, I would like to have another field labeled age. Is there a formula that I can create to have access calculate this in my table? I have tried "=mydate()-"Date Of...

Here is my problem: Let's say that I have a table with a field name of "Phone Number". I input about 200 #'s in the following format: xxx-xxx-xxxx. I decide that I want to use the an input mask to create (xxx) xxx-xxxx. I input 50 more #'s. The previous 200 have the old format while the 50...