Recent content by batesonm

Thanks again for your reply. I will have a look at the code when I get some more time to get my head around it. I have put in the following in the range paramater In_Hours_Overview!E1:E1 But I get the error message saying that it already exists?

Thanks Isskint, Reading that has blown my mind! I am thinking it may be easier to do another query. Do you know if it is possible to export the query to a specific cell within an exisiting worksheet in Excel? Thanks

Thanks for swift reply! @pr2-eugin - I am steering clear of reports as need the query to be usable in Excel but thanks for the link @Isskint - The calculated field is an idea but it would look a bit messy with it being on every row. I had thought about doing an additional query for it but...

Hello All, I have been searching through the forums for something that would be able to answer my issue but with no success :banghead:. I would appreciate if someone could point me to the right thread or take a look at my issue. I have the following query: SELECT [In Hours].Outcome...

There have been a fair few views of this but not answers. Does anyone have any ideas or point me in the right direction?

Just want to clear up what is actually happening. When I follow the import wizard and do not go to advanced and save the specification name the CSV I have imports fine with no errors. When I save the specification name and import the CSV it comes up with error table with file conversion...

Hi I am new to Access so please be gentle with me. I know that this has not been updated in a long time so am hoping that someone will be able to help. I have followed the process above. When I import the csv manually it all works fine. When I add this to a macro using the import...