Search results for query: *

Actually, it worked pretty well - the data is surprisingly consistent b/c it's generated by the county (state??) election database and there are four fields for the street address alone (house #, house # suffix, complete street name, apartment). Thanks for your help! Heidi

I used the find duplicates query wizard and it gives me this error: "You tried to execute a query that does not include the specified expression " as part of an aggregate function." (Yes, that's simply a quotation mark in the error msg.) in SQL view: SELECT [Blossburg Active...

Okay, I'm using this: SELECT A.BoxID, A.BinID, A.TicketID, A.BoxSerial, A.BoxDate FROM TicketBoxes AS A INNER JOIN ( SELECT Max(BoxDate) AS MaxOfBoxDate, BinID FROM TicketBoxes GROUP BY BinID ) AS B ON (A.BoxDate=B.MaxOfBoxDate) AND (A.BinID=B.BinID) ORDER BY A.BinID; Access will run it...

Beautiful!!! Thank you!!

I interpreted that as.... SELECT TicketBoxes.BinID, TicketBoxes_1.MaxOfBoxDate, TicketBoxes.BoxID FROM TicketBoxes INNER JOIN (SELECT Max(BoxDate) AS MaxOfBoxDate, BinID FROM TicketBoxes_1 GROUP BY TicketBoxes_1.BinID) ON TicketBoxes_1.BinID = TicketBoxes.BinID; ... which results in "Syntax...

Ooops, I'm sorry, I need to know what BinID that each is. When I add BinID to the query, it gives me all the records b/c BinID is unique.

Many thanks. I need to practice my SQL. :-)

This seems like it ought to be simple, but I'm having trouble with it... Table consists these fields BoxID (index/autonumber) TicketName (Lookup to a list of names & types of tickets) BoxDate (manually entered short date when the box of tickets was opened) BoxSerial (manually entered serial...

Access 2000 on Win2KPro Backend lives on nice server, contains 23 tables with 3 to 600 records each (2100 kb). Front end lives on individual users' machines. The front end has 20-odd queries, 20-odd forms and three reports. Granted, the forms are very complex with min. 3 subforms each. For...

Yes, that's the default cmd button wizard results, and yes, i've got the form set to continuous (checked, double checked.)

okay, that makes nice new records with the proper LoanID with no error but doesn't show me the existing records with that loan id.

okay, that makes nice new records with the proper LoanID with no error but doesn't show me the existing records with that loan id. i realized after I posted this that it was a forms question not a vba question, so i reposted there. i'm sorry. thanks for answering anyway.

Access doesn't really like having multiple users ... you should split the database so each user has his/her own copy of the forms/queries/other front items and the data all lives on the server in the backend.

This seems like it should be so easy... I've got a form, 1Loan, with an LoanID field. I want to use a command button on 1Loan to open a form, sysApps, that will only display the multiple records from a different table that have the same Loan ID. This code gives me an error on the...

cstr( )

This seems like it should be so easy... I've got a form, 1Loan, with an LoanID field. I want to use a command button on 1Loan to open a form, sysApps, that will only display the multiple records from a different table that have the same Loan ID. This code gives me an error on the...

I didn't think it was normal :-) Okay, here's code part 1: 'Get all loan records for this audit strSQL = "SELECT * FROM Loans WHERE [auditid]= " & aid Set rs = CurrentDb.OpenRecordset(strSQL) ' cycle thru loan records If rs.RecordCount Then x = 0 rs.MoveFirst Do While Not rs.EOF...

I'm using a recordset to run thru a bunch of records and evaluate various fields within each record. Access seems to be holding the value of fieldZ of recordA if recordB's fieldZ are not populated. Is this possible? And what can i do to clear it? Thanks, Heidi

I'm using DoCmd.RunSQL (strSQL) to add rows to a table. I want it to not notify me that it's appending a row - it's really irritating and the table is specifically for these added rows. How do i suppress that warning? Thanks, Heidi

ah, thanks! now, how do i account for the autonumber PK field "errorid"? or am I supposed to keep a counter going within my script? strSQL = "INSERT INTO errors VALUES ("errorid should go here & lid & "," & today & "," & ctapps & ", 1, 1, 1," & teststr & ")" Heidi I. Jones Ridgerunner...