Search results

thanks but in case there is another number, say 551, in another Number_List record, it might cause selection error: STockID Number_List ---------- ---------------- D001 1,5,57,299,551 D002 2 In the above case, actually, "51" does not exist in either STockID. But If i use...

Dear all, I have a table (TableA) in Access looks like that: STockID Number_List ------- ----------- D001 44,45,47,41,42 D002 1,2,3,5,58,60,61 D003 49,50,51,48,53,54 P.S. Both fields are having "Text" datatype. Now, I have to write...

thanks, but the wizard outcome seems not match my requirement

Dear all, Assume I have two queries getting similar records from different tables: Query1 ------- Select stockname, transaction_date, amount from TableA where transaction_date = #21-04-2009# Query2 ------- Select stockname, transaction_date, amount from TableB where transaction_date =...

good ;)... many thanks.. but it need money..:o , my company surely ban my idea.:p

thanks, but I just "import" the text file generated by the "export" function. When I import the exported text file, the above error was shown :o

thanks. Actually, I face a problem: I have a production Access Database and a development Access Database. As you know, development database is always changing (e.g. add some fields in a table, change the datatype of a field etc..).. I always have to "record" the changes down and then apply the...

Many thanks. :cool: I have tried the script. Actually, I don't really understand the contents of "exported" text files. I could not find any "create table" statement in the table object text files, which i suppose it will contain. Besides, there is an import error which say: " You canceled the...

hi all, The scheme that I mean is something like create database, create table ..index etc scripts. I believe John has got what I mean. But John, I would like to keep a script file (a text file) instead of "import" the objects from development database to production database. SQL Server...

Dear all, I have an Access Database with about 30 tables (include link tables) and 10 queries. Could I export the schemes of these 30 tables and 10 queries so that I can import these schemes to the production database? Many thanks :)

Hi DCrake, Thank you a lot for your kindly help. Since I am currently in company, and according to my company's security and privacy policies, I cannot upload anything in Internet, so, i just can do it tonight when I back home. Actually, I have a VB program which consists a lot of queries to...

So, in my VB programs, there are about 200 queries writing likes that: where format(ABC,'dd/mm/yyyy') = format(DEF,'dd/mm/yyyy') do you think i need to change it back to: where ABC = format(DEF,'dd/mm/yyyy') ? Many many thanks

If using this: where WDays >= format('10/04/2009','dd/mm/yyyy') The result will be FINE

Many thanks for your kindly help. I will delete the "Year" field, and currently, i am more concern about the FORMAT function because I have to re-write over 500 queries in my VB program in case the "FORMAT" is used in-correctly. Let us discuss on "FORMAT" first. :o I want to know, why if I...

ohooh.. I have tried: select top 1 format(wdays,'dd/mm/yyyy') as wdays2 from TableA where year = 2009 and WDays >= format(#10/04/2009#, 'dd/mm/yyyy') order by wdays asc The result is horrible, it returns 05/10/2009 why the behaviour is unpredictable and not consistent...

thanks for your prompt reply. 1. Yes, I have a field called "Year" 2. so, do I need need to write in this way? format(Wdays,'dd/mm/yyyy') >= Format(#01/04/2009#,"dd/mm/yyyy") for the comparison of left hand side and right hand side in the query? 3. i use "order by" because I want to make sure...

Dear all, I am really confused with Access Date field handling. I have the following query (assume TableA has a field "wdays" which stores all the dates in Year 2009): select top 1 format(wdays,'dd/mm/yyyy') as wdays1 from TableA where year = 2009 and WDays >= format('10/04/2009'...

Dear all, 1. Assume TableA stores the holiday dates (exclude Saturday and Sunday) of a year, HDays Year ----- ----- 01-01-2009 2009 10-04-2009 2009 13-04-2009 2009 ...etc 2.) Right now, I have to...

Dear all, I find that Access cannot use "group by" in the sub query. The following query will prompt up a message "Operation must use an updatable query." if being run: update Summary as s inner join (SELECT refno, sum(amount) as s_amount FROM Details WHERE Refno = '20090213001' group...

thanks for your reply. Actually, the formula is not the concern, my concern is how update can be used with iif function.