Search results
-
L
Help, query question about "finding a string"
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... -
L
how to compare two queries returned rows?
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 =... -
L
Question How to obtain the scheme of an Access Database?
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 :) -
L
[Urgent Help] select statement with Date Field
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'... -
L
[Help] How to generate working dates of a year?
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... -
L
Update statement cannot use group by?
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... -
L
Update query with iif function
Hi all, How can I do this in Access query? It say it has violation problem. But I really need to use iif function in this update statement. How can I workaround that? thanks! update t_header as h set h.price = iif(h.FX=1, h.amount/h.price, h.fx*(h.amount/h.price)) where h.Refno='1'... -
L
Update Query question -
Hi all, I have a very simple update query as below, it works fine in Access: update a, (select c.refno, c.price, c.unit from c) as b set a.price=b.price, a.unit=b.unit where a.refno=b.refno Right now, I need to sum the price and unit first before updating Table a. I just simply re-write...