Search results

Hmmmm, evasive query this... I have tables: tblEmployeedetails,tblParttimeEmp, tblFulltimeEmp,tblEmployee and tblClubs ParttimeEmp and FulltimeEmp are subsets of tblEmployee and thus all have the same PK(empid). TblEmployee is linked to the tblEmployeedetails via the same PK(empid)...

Well well well. I cannot believe I forgot how to do this... :rolleyes: I have 2 forms. EmployeeId on the tblEmployee and EmployeeId on tblSection. I want when I enter data in frmEmployee, when I click NEXT (to go to frmSection), that EmployeeId be there in frmSection.EmployeeId automatically...

Do you have a " some where in that query?

WHERE ((tblAccum.RecDate) = [Forms]![frmMain]![Text17]) Shouldn't that query be WHERE ((tblAccum.RecDate) =[Forms]![frmMain].[Text17]) take out the last ! and see if that works. Me thinks you're trying to reference a combo box (Text17) in another form (frmMain)...so it should a . not a ! and...

Hmm, I've been wondering and experimenting... :confused: How does one list all activities within the last month (and the month would be the current month, whenever the current month is) from a table such as: tblActivity activityid activityname startdate enddate I tried using the TODAY ()...

Hey, thanks for the tip. :D

For some reason, duplicate tables were created in the Relationships window on 2 tables that have a relationship between them. :confused: tblCampus tblSchool cam_id (PK) sch_id (PK) cam_name sch_name cam_id (FK) I used the Lookup Wizard to create a combo box...