Search results

Is there a way to create a "template" so to speak, so that when the material is updated, the graph is updated. I'm tracking the number of employees in disability by week for 4 months. I'd like to have two graphs, based on two queiries: 1. by site 2, THe company wide total I am finding this...

I have a table, used in a form, that records general information about employees, including an employee ID number. I also have a second table, called Duty Assignment, that is linked to the Employee table by the employee ID nmber. The main form is the employee table, and the subform is the Duty...

I want to greate a graph based on my data, but one that is automatically updated everytime the data changes (i.e. month vs. employee overtime or month vs. commissary sales). Is that possible? Also, the only way I can seem to get ANY graph I great to print as it is viewed on screen is to...

I have a table called staff injuries. It has a check box field to not an outside referral to a hospital, etc. It is called OUTREF Because I am interested in things like average number of accidents/week, etc. I also have a check box field called NONE. That way, the correct number of weeks...

I'm tracking overtime between various locations. Each site has to sumbit a weekly summary of their activities. I'd like to calculate the %change in overtime from week to week. How can I do that task? Thanks! Gayle Ann

I'm not sure I understand. I've done somethign similar with dates, but but not time. I was looking at the age of parents at the birth of their first child. I had the birthdate of the first child and the birthdate of the parent. I used the date difference, which I think, outputed the data in...

What is the syntax to use the above formula, but to specify NOT a specific value. For example, what if she wanted all values EXCEPT C? Thanks. Gayle Ann

What is the syntax to use the above formula, but to specify NOT a specific value. For example, what if she wanted all values EXCEPT C? Thanks. Gayle Ann

I don't understand the D* functions, and can't seem to find reference to them in help. In a query can I total the number of records, and then find the MIN, MAX, and AVG of the number of records? Thanks. Gayle Ann

I don't know that I have an answer, btu I think I'm trying to do somethign similar. Can you explain the syntax? I can'd find anything in help on the D* commands. Thanks.

Hello, Can the AVG, MIN, MX functions be calculated from unbound fields? I tried looking at the help topics, and really didn't receive much insight. I can total the number of records per site per week, but can't seem to do anything with those figures. Thanks. Gayle Ann

Is there a way to calculate summaries for text fields? I am designing a database for work. There are 33 sites. I have a table that records the new employee injuries by week and site. I can do a count and determine the total number of injuries per site, but I'd like to know the average per...

Rich, Bless you! You are my new hero in life! Gayle Ann

Where is the Yes/No help section? Thanks. Gayle Ann

Error message I got the following error message when I used it in the query: You tried to execute a query that does not include the specified expression <name> as part of an aggregate function. (Error 3122) You tried to execute a query that does not include the specified expression as part of...

Hello, Do I use that expression in a query or in a unbound field in the report? I tried it both places and it doesn't work. I've tried the help files, but... You need to know WHAT you are looking for before they are of use. I am SOOOO frustrated. I know this is somethign simple, but I'm...

Hello, I tried that, but it doesn't work for this type of table. The fields I need summed are yes/no, so it just lists YES for everything. It doesn't tell me how many YES answers I have and and how many records total. For example, assume I have 2 injuries, each with their own record. One...

I have a table called Staff Injuries. Each record is linked to a primary table through two fields: site and week, both of which are primary keys. (Thanks to someone for suggesting a compound primary key). This is a secondary table because it can have more than one answer. While the record...

Thanks. I actually figured out the posted problem, but now have another. How do I design a filter that lets me make a request? For example, I designed a database for weekly reports form 33 different sites, using site and date as the compound keys. Figured out all the relationship things for...

Hello, I am designing a database with the informatin in weekly reports submitted by 34 different sites. A few of the questions can have multiple answers (ex. staff injuries). I have a primary table comprised of fields from questions with only one answer (ex. number of employees). The primary...