Search results

Is it possible to sort different ways in a report based off of a specific header? Here is what I have. I am working on a database that prints out the best track and field times. For running events, you want the times to be sorted from smallest to largest, for field events, you want the...

Thanks once again!

I have one other question about what you did. Is there a way for me to do an "and" statement so that the query is then filtered by two fields? Something like this: Dim stDocName As String stDocName = "rptTrackRecords" DoCmd.OpenReport stDocName, acPreview, , "[Gender]='" &...

I have one more question about my report. I currently have a report that organizes records from smallest to largest, and I only want the 10 lowest to show. So I have the following hard coded into a report: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If txtRCount > 10...

I tried it this morning, and it works beautifully! That little piece of code is going to really change the way my database is setup and will make it a lot more simple. Thanks again!

Thanks. That sample really helps. Conceptually, that is exactly what I want to have happen - different sets of criteria for the query to be filtered by. Currently I have a different query for each scenario. I will try that this weekend and see how it works.

Does making an extra query for each situation greatly increase the size of the database?

Currently I have a report that is based off of a query, and the query has a field that asks for a parameter value when it is run. I know why it comes up, but I don't want to see it come up. Is there a code that I can use that will automatically fill in a null value when box pops up asking for...

Thanks - that did exactly what I wanted it to do.

Hi - I am creating a database that tracks all of the statistics for our track and field team. I am running into one issue though. In a field that I call "Final Result", I am having a running event automatically created calling the following: [FinalTimeMinutes] & ":" &...

So do you use a setup like I do with a separate field for minutes and seconds?

I am trying to setup a database for some track and cross country runners in order to track personal stats, however, I am running into an issue. I want to make the database I have more efficient, but the issue I am having is how to setup the final time field. Currently in my database is setup...

Could you elaborate on how I would begin to setup that rule? I just can't wrap my mind around how to handle it because if I base the current year off of the year of graduation, for part of 2008, the class of 2008 would be equal to 12, but then the fall of 2008 has the class of 2009 equaling...

Hi - I have a database I am working on where I am tracking our current students. There is a field in my table of student info called YearOfGraduation, which is 2008, 2009, 2010, etc. On the form where the user adds students, there is a calculated field called "Current Grade." I would like to...

Yes, all the information is in a single table. The setup is the primary key is an auto number, and every other piece of data in the record needs to be copied identically into a new record, except for that it is one year later on a corresponding day. I can figure that part out, but the part I...

Currently I am working on a program to track athletic contests at the high school I work at. (Current program does everything, but way too costly each year). One feature we need is a "rollover" feature, where a button can be added to copy a record but change the date by one year. Not...

I am not sure where to post this, so I am trying the general forum. What I have right now is a very simple access database for teachers at our school to use - it has a field for who the announcement is from, who the announcement is for, the announcement, and the date the announcement is for...

Can this be done with a single, flat file, non-relational table? I think that is where I am having my trouble understanding how to set this up. The table is imported from Excel, so it doesn't have any relations built into it.

Thanks. I am slowly coming along. How do I go about selecting the column headings when the column headings are the results in the field, and not the field itself? Each of the questions should be a row, and the values should be the number of times an answer was chosen for a teacher on a given...

Thanks once again for your help! The only issue is that I can only choose 3 fields, but ultimately I would need 5 - one for each level (excellent, above avg, avg, below avg., poor.) How would I go about working with that?