Search results

Expr1: Format("012P","0000") , this expression should get "012P", I think this is a Access 2007 Bug, Expr1: Format("011P","0000"), we also get wrong result ....

Hi, Anyone know? when I use this function in Access Query design grid, we get wrong result? Expr1: Format("012P","0000") Why I get "0001" thank you ! My Access Version is Access 2007.

paste your code here, then we can be help...

Thank you, Mike; They give a short code to achive this. Seems no better method to get this done by SQL.

Thank you Alisa; If we have hundreds of products, then we need involve hundreds of fields involved in the Select query, for most time, the number of products name are not the same all the time. Best Regards

thank you for yor reply, but cross tab couldn't get what i want: i need two column table, if by cross tab wizard, it will generate multi column dtable.

May i reach following function by Grid Query design or by SQL Original: ============================================== Factory 1-----------Product A Factory 1-----------Product B Factory 1-----------Product C Factory 1-----------Product D Factory 2-----------Product D Factory...

for example: Macro will export to EXCEL with different name for every run. For example, I would like code macro like this way: DoCmd.TransferSpreadsheet acExport, 8, "A0020_ASSY_OPER_WIP_REPORT", "" "D:/ASSY_WIP_RPT_DH" & Hour(Now) & ".xls", False, "" But it couldn't work, why?

Could anyone give me kindly help? please see attach..

Please try this, by the way if you have deferent name under your group combine, then this code is not work..

Thank you all for your great ideas! May I ask another question? May I use : Fields(3).name replace workWeek1, Fields(4).name replace WorkWeek2, Fields(5).name replace workWeek3, or similar method in Access? because WorkWeeks fields always begin AT 3TH COLUMN. SELECT Table1.NameField...

workweeks fields number is not fixed. But suppose that we only have 10 workweeks fields, how to do this? thank you.

Thank you, The Table1 is not under my control, so I intend to convert the Table1 to the Second table2 Format to make it easy to handle. I usurally do this by VBA and ADO before. I wonder if we can have another easy method to do this?

Thank you, Newman, May be I am not make it clear, I mean, Can I design a query to to get second result? thank you.

I intend to convert the table 1 to Table 2, do I have good method? Table1 [name] [age] [workWeek1] [workWeek2] [workWeek3] Marry 20 10020 23302 24000 table 2 [Name] [age] [workWeek] [Value] Marry 20 workWeek1...

Please try this:

Thank you, Pat Hartman: It seems I got your idea. Do you mean i need write a procedure to find the same field names of two tables, then dynamicly generate a SQL string by concatenating those common fields?

Table 1 fieldName1 ----<fieldName2>---- <fieldName3>---<fieldName4>------------- Table 2 --------------<fieldName2>---- <fieldName3>---<fieldName4>---fieldName5 I want to get result as following by Query(don't list fields name in query): --------------<fieldName2>----...

Thank you! but , to make it more flexible,I don't want to list the fields name in SQL. I just need to union the corresponding fields of two tables, do you have any idea?

Table 1 fieldName1 ----<fieldName2>---- <fieldName3>---<fieldName4>------------- Table 2 --------------<fieldName2>---- <fieldName3>---<fieldName4>---fieldName5 Could you kindly tell me how to use "join" to Union two tables which have fields like above? the new table should have like...