Search results

Thank you all for your suggestions. From some research, this is what I’ve come up with: Public Function AugDefComp(dcjulff, fm) As Long Dim xValue As Long Dim db As DAO.Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Select federal, deffcomp From [fy 2002 employees...

Thanks for the replies, but I think I’m still lost. I don’t think I understand your questions and comments. Rich, I looked in help and found something like the following: Dim dbs As Database Set dbs = CurrentDb() Dim tdf As TableDef Set tdf = dbs.CreateTableDef("fy 2002 employees eff date")...

I'm kinda new at this and I've been trying a lot, but I can't seem to figure this out. I have a query which says it's too complex when I run it. I've tried many ways to divide it into smaller queries, but I still can't get the whole thing running. I saw a post where someone else had a similar...