Search results

Thank you very much Gasman, I will follow that thread.

Perfect, it worked, thank you very much for your help, arnelgp. It does exactly what I wanted it do. Now the next battle is to calculate number of days between start_date and end_date, excluding Sat, Sun, bank holidays and the start day. I probably need to start a new thread as this one is...

Hi The_Doc_Man, arnel, thank you very much for your help and suggestions. isladogs - I will try your procedure. thank you Meanwhile I managed to achieve the result with 4 update queries, so updating end_date with the earliest dates from each date field, where it is not null. It is not ideal...

Galaxiom - thank you. I understand. It is not a structured database, I am just working out a quick way to manipulate a large amount of data in Access as Excel cannot handle and keeps freezing. All I am trying to do is quickly import a large amount of data in a table and add some new fields...

Hi, end_date is date/time type, however it doesn't like #1/1/1900#, I get syntax error in update statement error. It okay for it to be left blank if it is easier.

arnelgp, I get syntax error in date in query expression.

Hi June7, MajP, The Doc Man, thank you very much for your suggestions, really appreciate your help. Update query by arnelgp worked for me. It is perfect apart from updating text "No date" in date/time field. which is fine. Thank you very much arnelgp. Instead of "No date" is it possible to...

Hi, I want to update a column called "end_date", in table "inp_Data", with an earliest date available in these four column: "F_date", or "G_date", or "H_date", or "I_date", If all four columns are blank then update "end_date" to text "No date". Can this be done in a single update query? I...

Hi arnelgp, thank you very much, really appreciate that. I will try it tomorrow when back in office. Thanks again

Okay Thank you very much for your help. I will work on it as you suggested.

I have tried the query with Indexing fields as suggested. To be honest it hasn't really made any difference. There is no PK in both tables, and nothing else I can join by. It is a 1 to 1 join. If I were to try VBA code, can someone please help me with writing it for me? thanks

Hi all thanks for your comments. It is an access 2013 database designed to process some raw data. The query takes about 25 to 30 minutes run. The query is updating tblFinal.Customer field every time a CodeNumber is within a Range of values. There about 10000 customers in the tblList. My aim...

Thanks all, I will try between and indexing as suggested. @jdraw - datatyoes for tblFinal.CodeNumber, [tblList]![StartRange] and [tblList]![EndRange] are number. It is a single user file database on window 7 PC in Access 2013. Number of records can be between 800k to 1million apx. Thanks for...

Hi, can someone please help. This update query takes very long time to run. Just wondering if this can be achieved with VBA perhaps it will be quicker to update customer field based on criteria in query below. UPDATE tblFinal INNER JOIN tblList ON tblFinal.Type = tblList.Range SET...

Ah I understand it now. I will follow your advice when re-developing this database soon. Thank you very much for your help.

Hi, thanks for your response. Not sure if I fully understand what you mean by make tables and append queries are used as training wheels for people who aren't great at visualizing data. Anyway, the purpose of this table is to count number of saturdays and sundays and any other bank holidays...

Hi Thanks for both responses. I will try your suggestions. It's a single file standalone database in Access 2003. I use the database to import large text files so i can manipulate these, do some calculations, add some reference columns and export into csv format in a structure format for monthly...

Hi there, I have following make-table query within a macro which contains a long list of queries, in Access 2003. Normally when processing small dataset, this query runs reasonably quickly. But when processing large data, this query takes hours and then I often get an error that cannot open...

That is brilliant. You are a star. Thank you very much for your help.

Hi there, I have a table with thousands records in Access 2003 database. I want to be able summarise data from 2 fields. These are Country and Durations. I want to count number of durations for each country. I have attached a spreadsheet with some dummy data and an output table that I would...