Search results
-
A
Expr1: Format("012P","0000") Why I get "0001"
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. -
A
How to transform data to crosstab-like format?
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... -
A
How Macro export to EXCEL with different name for every run.
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? -
A
How to apply filter on form?
Could anyone give me kindly help? please see attach.. -
A
Can ACCESS do this just by Query
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... -
A
can ACCESS execute SQL like "UNION CORRESPONDING"
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? -
A
how to check if a table exits in ACCESS with VBA or Macro?
how to check if a table exits in ACCESS with VBA or Macro? Thank you -
A
How to open a Access file exclusively just by double click the .mdb file name?
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! -
A
How can I transfer CrossTab to origial format?
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... -
A
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? 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... -
A
How to get Table3 's result by query?
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...