Search results

The problem is the tests' Pre-Post status isn't always constant. Eventually, the database will have multiple tests for many users--only the count for new students' tests will be 1. The most recent test date will be the posttest, and the penultimate date will be the pretest. However, once a new...

I think I understand (at least a bit) what you're saying. You were asking why I was GROUPing by certain fields in an earlier post; I guess it was my beginner way of having those fields show in the query results. Thanks again for all of your help!

I have a multi (multi multi) field form for Student Information data entry, and I will not be doing the entry. Would it be better to have one form to look at to tweak the existing data (ex. a student has a new address), and a different form to do the original data entry? I know that it's very...

I would like to put a signature below my posts; at a minimum, it could say what version of Access I'm using. Is there a way to have a signature appended to your posts automatically?

So if you have a query where you're aggregating a field (and therefore need the totals row in the Query Design Window), but you want to show other fields in the returned record, you have to do a work-around? Is this a flaw in Access, or is this something that SQL also requires? As you said...

Missinglinq, I am using Access 2007, and right you are! I already had "overlapping windows" checked, but I guess I had not closed and reopened the database since I had worked on that particular form. Now form looks great without a lot of wasted white space. Thank you so much!

There are no other controls there. If you look at the Design View picture, I have shrunk the work box as much as possible, but in Form View there is still that huge white area between the bottom of the tab box and the footer.

Pictures of my form in Form View and Design View are attached. All the tab controls are the same height as the one showing in the picture, and there are no other controls between the tab control and the footer. Some of the tab controls have subforms on them, but the subforms are all smaller than...

As to the grouping you mentioned in post #2: I'm a SQL newbie. When I try to remove all but StudentID from GROUP BY, I get an error from Access "You tried to execute a query that does not include the specified expression 'TestDate' as part of an aggregate function" (I get that error from any...

Thank you for your reply. I ran your query (results shown in photo qry4)and it did not show all the requisite tests for student 156 (who had both reading and math on 8/1 and again on 8/27, which is not shown), students 188 and 189 each had two tests of the same type on different days (your...

This question is a long two-parter. (1) I have query with student testing information. I would like to make a new query to show only those students who have taken a post-test. The query I have now is qryTwoLastTests SELECT a.StudentID, a.TestDate, a.TestTypeID, a.TestType, a.SSNum, a.GENum...

Having a 0 is fine, since I will need to perform calculations on this field. I appreciate the quick and useful help from all!!

I have a field SS of the text data type that contains numbers and plus signs, ex. 208+ . I need to perform calculations on the number, so used the Access expression SSNum: Val ([SS]) in a query. This works fine and returns just the number without the +. However, there are some SS fields that are...

(Macro/VBA newbie) I have a form that displays data for tutoring pairs, one pair at a time. I have a cmd button on the form that rolls over the pair; i.e. it opens an append query that inserts the current pair's StudentID, TutorID, and the new AcademicYr in tblPairs. That macro is working fine...

Hello everyone! I am terrytek from the USA. I am the "accidental techie" (i.e. no formal computer education) for a small non-profit. I am self-taught in Access, but need a lot of help. Thank you in advance to all of the experts here who help the rest of us get it done!:D