Search results

Hello I would like to have a query look for a field value of ABS in a text field called Code1 and then only give me the count of records >13 per student. This is a student database and this is the count of their absences. My table is names tblAttendance I have been successful in getting a...

Hello I want to have a user pick a combo box on a form and once that supplier name is chosen - an after event procedure fills the contents of a field called account number, in the same form, based on the value in a table that corresponds to the supplier name they chose. Here's what I have now...

Hello I'm looking for a general answer on a situation I'm having with an inventory database. I'd like to ship multiple items at the same time by adding records to a transaction table based on a criteria match from the item number table. An update query only updates existing records. Because...

Hello I have a query fed by 3 tables and 2 queries. For years the query displayed my data with no problems. However, when I added a large number of extra fields to what was already a large number of fields I get the error above. I've found that if I delete 12 or more fields the query will run...

Hello Everyone Instead of having a parameter query ask beginning date and ending date I'd like it to just ask for the year and then have my query display records for that year. Is there a simple way to do this?

Hello I have a political database with a separate field for street number, street name and apartment number. I've been asked to prepare a query that will only list the first member of a household. Example, the query would only show one member from a two person household if they both have the...

I am a teacher in a public school system and have developed an Access database that is used in 3 different schools in our city for after school programs. Everything started out good as all the schools had Access 97 which I developed it in. However, in the last several months several of the...

Hello I have been asked to add time-in and time-out fields in a database I have. That's no problem but I'd like a calculated field on my entry form and later on reports that calculates the hours worked as number/decimal. By this I mean if someone worked 8:00 am - 9:30 am they would have...

Hello Everyone I'm a new member and unfortunately joined out of necessity. This afternoon I performed a Repair Database command in Access97. When I went to perform the Compact operation I got the following error: "The MS Jet database engine could not find the object "Databases". Make sure...