Search results

OK, will do, thanks.

Students can't get more than 7 in one day, but they can get as many as 7 on any given day. The school counts the total number of tardies. How many they get in one day is not relevant. It's how many total they get over the course of the semester. I only include how many tardies they get per...

Pat Hartman - Yes, there are 7 pds in a day. It's possible a student could be late to every period and have 7 tardies in one day. The school counts the total tardies, so it's how many they accumulate over time. Right now, I have a way to see if they got a tardy for today and they've reached...

Tardy is simply, late to class. I don't think I can post data, all I have is live data and I'm required to protect the privacy of the students. It will take some time to put together some dummy data, will try to do that in the next couple of days.

Another way to do this might be to have a column that counts the number of records for the student on the date. If they have 8 tardies and have more than one record for today, that would mean they got both the 7th and 8th tardy today. Just not sure how to write the statement for that column in...

Yes, it will display tardies of 7 or more, but I don't want that. I only want students who have reached 7 today OR have multiple tardies and have reached 8 tardies by having more than one tardy recorded today. Since the query identifies only students with 7 tardies, I need to add a column that...

The query works as expected, I just need to add in the specific circumstance of students getting those multiple tardies on the same day and skipping over the 7th tardy threshold. Thanks SELECT [Tardy CURRENT TOTAL Query_Crosstab].[Last Name], [Tardy CURRENT TOTAL Query_Crosstab].[First Name]...

Title may not adequately describe what I'm trying to do. I work for a school and I'm developing a way to track student tardies. I need a way to determine if a student has received multiple tardies in a single day and to count how many they got on that day. Specifically, we have a threshold of...

Our official email client is Lotus Notes, but I could probably use/install Outlook and make it work for this purpose. I have access to all the email addresses I would need and could easily add them to Outlook's address book. BTW- I have used Lotus Notes to attach output files from Access and...

Would it help if I attached the database with dummy data. I have to change the data because it involves students at my school. In a nutshell, I'm trying to create this distribution for my school. It's to help teachers and in turn, students. I'm trying to automate the distribution of this report...

Maybe I should change my status to Novice...haha Looks good. I can try this tomorrow and see if I can get it to work. So I will need to create a form and use this code on a button on the form? Do you know if this will work with all email clients? or is it specific to Outlook? Also, what is the...

AHH, I see what you're saying. Where exactly do I enter the code, View Code?...(design view) If the identifying field is an employee # for each person, what would the code look like?

I don't think that will work for me. The report will have data for about 160 people and I don't want to email them one at a time. I'm trying to automate this, so that I can mass email the whole report to the individual person and the email will only have the pages that apply to that person. It's...

I'm trying to come up with a way to email pages of a report to the person the page of the report has on it. Each page of the report has data about an individual person, some people will have 2-6 pages of data, others will have only 1. Is there a way to automatically email only the pages that...

The only way I could get this to work was to create a subreport with the field I was by putting in Details and place the subreport in the student id footer section. Once I did that, everything displayed correctly, including the columns. Of course, I had to set Master and Child fields so that the...

OK, got the Details to display correctly, but I still have the same problem with items placed under the student id header/footer. Looks like the columns cover up the info under those headers. It's got to be a simple setting somewhere.

Yeah, I've done this several times and it doesn't do what I want. I'm missing something. I go to Columns, enter 2 for number of columns, uncheck the box (same as detail) reset the column size width to 2.5, it puts the whole report in one column, Like it's cutting off the rest of the items (like...

I'm trying to run a report that has 2 columns in the Details. This report is for a school and all the data is grouped by student id. However, some students may have up to 10 items listed in the Details, so I want to split it up so that the report will fit on one page, rather than a single...

I believe because of the way the data is stored it would be much easier to pull the last 4 most recent dates. That might get rid of most of my problems, but my administration asked for only the last three. Going to keep working on it.

Thanks all. I have this very close to working for what I need. I ran into a problem because my SIS query pulls the data from our Student Information System (SIS) by "year", so since some students may have 4 courses in only two years the database pulls four returns for some students in Access. I...