Search results

I had thought of that, but was hoping there was something a little less manual. I'm grateful for your opinion, as at least I can now continue along that route knowing it's potentially the best I can do.

Hi. I am exporting data from Excel into Access temp tables and then trying to write update/append queries to transfer the data to permanent tables. I have this scenario: STAFF table StaffID [Autonumber] [PK] StaffCode PRODUCTIVITY table ProductivityID [Autonumber] [PK] Date StaffID [FK to...

Hi. Firstly, I hope this is the right forum. I wasn't sure if this was a Query issue or something more general. I'm trying to update tables in my DB using temporary tables which have been imported from Excel. I have set up Unmatched and Duplicate queries and then Append and Update queries for...

I think I've stumbled across a solution (not necessarily the best one). I created a SELECT query pulling in all fields from the StaffLoginTelephony table except for the StaffLoginNumber, which I pulled from the linked StaffLogin table. I then used this query, instead of the StaffLoginTelephony...

Hi. I know this is a fairly common problem, and have trawled both these forums and Google to try and resolve it, but I still can't so I hoped that posting specifics of my DB might help. I am importing data from Excel to a temporary table (with no PK) as follows: tblTEMP Date Login (actual login...

I'd be really grateful if someone could take a look at the code here to see if they can spot what is keeping Excel alive. For now, I am calling a KillExcel function, which is doing the job, but I don't want to do it this way. Private Sub cmdImportWorkflow_Click() On Error GoTo...

Thanks for your response. Copying and pasting your SQL directly didn't work, but I managed to follow your reasoning and got it to work. What I hadn't done in the Query Window was to add a SECOND instance of ActivityDate (not shown) and add the criteria for StartDate and EndDate in there. Now...

I'm trying to create a Staff Database to track hours spent in various activities each day. Each member of staff is in one team at a time, but moves between teams. I've simplified my table set-up for demonstration Staff StaffID - PK for Staff table StaffName Team TeamID - PK for Team table...