Recent content by BruceFrey

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