Search results

Hello everyone, it's been a while, anyways, I've been trying to tackle this on my own for about a week and can't seem to solve this. Anyones help is much appreciated. I have a query that calculates how many meetings a course meets per month depending on the start and end dates and the...

Sorry to have to repeat this question, but I have spent about a week trying to figure this one out. Here is what I need my database to do. I created a database in Access 2000 and am currently working on it in Access 2002. The database generates agreements for each faculty member in our...

I am working on a report in MS Access 2002 that resemble an old report done in Excel but cannot format a label to ensure the report stays on one page (landscape). In Excel, the properties of the cell can be modified in order to have the orientation set to 90 degrees. By default is set to 180...

I have two queries, one that has Faculty Assignements and another table that has the Faculty Assignments Detail of each course. I created a field called [FacultyCourse] which is FacultyID & Assignment. table FA does not have duplicates in [FacultyCourse], while table FAD does. I need to...

I am looking to get a main instructional method for a each course that exists in a query. I query a table that has all the assignments which gives me duplicates. I grouped them to get a short list with a few duplicates if the course has two instructional methods (i.e. Lecture & Lab)...

Forgive me, but this would be my first time ever creating a database from a flat file. The flat file that is being sliced and diced many ways to get values needed for payroll and assignment tracking. The way I am handling it now is that I am creating chain queries and am realizing that the...

Need some help with yet another rounding issue. The data in bold are the only two pieces of data I have given to me. This in red are calculated through a series of queries. StartDate = 06/09/08 EndDate = 08/01/08 Weeks = 8 TotalDays = 54 TotalWeeks = (54/7) = 7.71 Month1Days = 22 Month2Days =...

I need to convert a numeric value into two values (Whole & Part). For example, 2.400 is the numeric value for field ContactTime. I need two seperate numeric values for fields called Hours = 2.000 and Minutes = 0.400. ContactTime is a calculated field that uses the DateDif() between two times...

I have this table (imported from a text file) with a field name called COURSE. The value of course is a text field, with a format of ACCT-101-501. I need to seperate the value into three sections where the delimiter is "-". I currently use Excel to seperate (text-to-column) and then copy it...

I have a database which has two tables (instructional and non-instructional assignments). The Instructional table is a table that is imported from our campus database (data entry done by canpus). The Non-Instructional table is a table that is manually keyed and maintained by me. A faculty...

I tried to search to see if this was brought up before, but don't know what this is called. Sorry if this was already solved and hope you can give me the keyword to search. I am working on a query that counts the number of ethnicity responses for each active job posting. We have a online...