Search results

Hello David Thank you, I pasted this sql code into a new query and it works! I'm curious though, originally you had suggested that I use Absent:IIF([Code1]="ABS"),1,0) this syntax as my new field. Did you find that this was not necessary? Again, that you for your help. Regards Bruce Frey

Hello Can you upload the test db back so I can see if there is anything different you did vs. what I did?

Here is a striped down version with no names etc.

Hello Here's what it looks like at present SELECT tblAttendance.[FORMAL NAME], tblStudents.[GRADE LEVEL], tblStudents.Shop, tblAttendance.CODE1, Count(tblAttendance.CODE1) AS Total FROM tblDownloadDate, tblStudents INNER JOIN tblAttendance ON tblStudents.APID = tblAttendance.APID GROUP BY...

Hello David I'm trying that but after I paste the syntax you suggest as a new field in my existing query I get an error that says "The expression you entered has a function containing the wrong number of arguments" What do you advise?

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 Thank you! Your suggestion worked great!

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...

Thank You Thank you for the heads up on the SQL view. I went in and changed the view and was successful in changing the parameter query to asking for the year. Thanks again for responding.

reply to parameter query for year Hello Thank you for the response. I'm in my parameter query now and can't get it to work. I'm trying to type the following into the criteria part of the query =WHERE Year([Date]) = [Enter a year] Did you want me to type this somewhere else?

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?

Thank You Thanks Pat, everything worked great!

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...

Pat Thank you for your prompt reply. So, I don't have to search the contents of the hard drive to find a particular file? Access will find the file itself if I do as you suggest?

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...

Thank you both for your suggestions. I've tried them and they both work great.

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...