Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
btamsgn
Starting Member
4 Posts |
 Posted - 2007-12-05 : 04:57:47
|
| Dear All,I have a form excel, at I'd like to use microsoft access to manage my data however I have a problem with query and report in access.Pls help and give a code to have a report like the attachment formated by excel. Looking forward to receiving your help. Oh, sorry sorry, I don't know upload file in the forumPls help & guide, thanks!Thank you . -----------Tammygreenmaple@vnn.vn[EDIT by tkizer] thread moved to Access forum |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-05 : 07:17:31
|
| Try using TRANSFORM. Do google searchAlso you should post your Access related questions at MS Access ForumMadhivananFailing to plan is Planning to fail |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-05 : 18:06:23
|
You put the table in Access, and query the data right from excel and pull it directly into an excel pivot table
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
btamsgn
Starting Member
4 Posts |
Posted - 2007-12-05 : 20:36:19
|
Thanks for your helpHowever, I made but report or query not like formexcelYou give your email, I'll send a attachment for your reference.my email : greenmaple@vnn.vnThank youTammyquote:
Originally posted by dataguru1971
You put the table in Access, and query the data right from excel and pull it directly into an excel pivot table
Poor planning on your part does not constitute an emergency on my part.
|
|
|
|
|
|
|
crosstab in access