Search results

Thank you, I detail it as following.. Table 1 fieldName1 ----fieldName2---- fieldName3---fieldName4 Table 2 fieldName2---- fieldName3---- fieldName4---fieldName5 I need Union corresponding fields into new table... but following SQL failed Select * from Table1 UNION Select * from Table2...

can ACCESS execute SQL like "UNION CORRESPONDING", I need this type SQL to make my application more flexible, but I found ACCESS doesn't recognize it! what other method should i do?

how to check if a table exits in ACCESS with VBA or Macro? Thank you

Thank you, WayneRyan;could you detail it? Thank you, WayneRyan;could you detail it? Amolin

How to open a Access file exclusively just by double click the .mdb file name? I means Just by double click the .mdb file name, the Access file will automatically open exclusively. Thank you!

I see,Thank you!

Thank you ! But if the column number of crosstab is not fixed ,how can I do? By the way,I don't need sorting in result table . Thank you again..

For example: I want to transform this table Name Jan Feb Mar Apr ................... David 5 6 8 5 to Name Month Number David Jan 5 David Feb 6 David Mar 8 David...

I See,Thank you very much!!!

Sorry, I couldn't get the correct result as I need by simply drag other fields in to query 2, because there are "total" row in design grid. Do you have any other idea? thank you! B---------2004/22---------10---------2121---------4000 B---------2004/22---------22---------2121---------2222...

Thank you; But the result ColinEssex provided is not the exactly what I want, I need to select the entire records which max LIMIT corresponding to . thank you,ColinEssex.

Sorry, I will detail it as follow: for follow records: B---------2004/22---------10---------2121---------4000 B---------2004/22---------22---------2121---------2222 B---------2004/22---------8---------2121---------2000 B---------2004/15---------8---------1221---------2000...

How to select the records corresponding to max "LIMIT" when "FG" and "WW" are same? How to select the records corresponding to max "LIMIT" when "FG" and "WW" are same? for FG---------WW--------LIMIT-------QTY---------QTY2 A---------2004/12---------6---------2001---------1000...

Thank you for your idea! but the age bracket is not always 10 years, so could you have any idea to work out this? By the way, the table1 and table2 is not of my control,so I could not revise Table1 and and Table2's structure. Thank you again!

Hi, all, I have a big difficulties; How can get the table 3 's result from table1 and table 2 by query? Please see attachment. table1 Name-------Age a-------12 b-------25 c-------33 d-------38 Table2 Age Limit-------Ticket Price 10-------------15 20-------------25 30-------------35...