I'm not a fantastic Access developer, but I'm trying to help get
Inventory and whatnot organized at work. They are used to 5 year
budget plans that list out exactly what has to be purchased what year
and how much it will cost. Currently these are kept in Excel and look
like this
| Inventory information (who, what, where) | 2008 | 2009 | 2010 |
2011| 2012
The cost for the item is displayed in the column in the year when it
will be replaced,and summed, for department, as well as for the year.
I have all of the information on the item stored in an Access 2007
table, with the who what wheres in their own fields, and fields for
replacement year and replacement cost. What has me stumped is how to
format a report so that it looks like the Excel format I tried to show
above, without having to do a whole bunch of manual tweaking anytime
it is run, AND without having to re-export to Excel.
Is this something that I can pull off in Access? Is anyone willing to
give me a shove in the right direction?
Thanks!
5  2338 
On Jan 15, 2:24*pm, LadyIlsebet <amy.s.coo...@g mail.comwrote:
I'm not a fantastic Access developer, but I'm trying to help get
Inventory and whatnot organized at work. They are used to 5 year
budget plans that list out exactly what has to be purchased what year
and how much it will cost. Currently these are kept in Excel and look
like this
| Inventory information (who, what, where) | 2008 | 2009 | 2010 |
2011| 2012
The cost for the item is displayed in the column in the year when it
will be replaced,and summed, for department, as well as for the year.
I have all of the information on the item stored in an Access 2007
table, with the who what wheres in their own fields, and fields for
replacement year and replacement cost. What has me stumped is how to
format a report so that it looks like the Excel format I tried to show
above, without having to do a whole bunch of manual tweaking anytime
it is run, AND without having to re-export to Excel.
Is this something that I can pull off in Access? Is anyone willing to
give me a shove in the right direction?
Thanks!
Can you give us your table structure(s) please?
On Jan 15, 2:34 pm, frogste...@yaho o.com wrote:
On Jan 15, 2:24 pm, LadyIlsebet <amy.s.coo...@g mail.comwrote:
I'm not a fantastic Access developer, but I'm trying to help get
Inventory and whatnot organized at work. They are used to 5 year
budget plans that list out exactly what has to be purchased what year
and how much it will cost. Currently these are kept in Excel and look
like this
| Inventory information (who, what, where) | 2008 | 2009 | 2010 |
2011| 2012
The cost for the item is displayed in the column in the year when it
will be replaced,and summed, for department, as well as for the year.
I have all of the information on the item stored in an Access 2007
table, with the who what wheres in their own fields, and fields for
replacement year and replacement cost. What has me stumped is how to
format a report so that it looks like the Excel format I tried to show
above, without having to do a whole bunch of manual tweaking anytime
it is run, AND without having to re-export to Excel.
Is this something that I can pull off in Access? Is anyone willing to
give me a shove in the right direction?
Thanks!
Can you give us your table structure(s) please?
Everything I *think* I need for this report is in the one table.
Name Type Size
AutoNumberKey Long Integer 4
Asset Tag Text 10
Inventory Type Text 25
Assigned Text 50
Description Text 255
OS Text 255
Department Text 255
Location Text 255
Serial Number Text 255
Purchase Date Date/Time 8
Purchase Cost Currency 8
Replacement Year Integer 2
Replacement cost Currency 8
Notes Memo -
WindowsUpdateDa te Date/Time 8
WindowsUpdateTe ch Text 255
VirusDefsDate Date/Time 8
VirusDefsTech Text 255
VirusScanVersio nDate Date/Time 8
VirusScanVersio nTech Text 255
Is any more info needed? The report will not need to include any
fields listed after "Notes"
Thanks!
On Jan 15, 3:30*pm, LadyIlsebet <amy.s.coo...@g mail.comwrote:
On Jan 15, 2:34 pm, frogste...@yaho o.com wrote:
On Jan 15, 2:24 pm, LadyIlsebet <amy.s.coo...@g mail.comwrote:
I'm not a fantastic Access developer, but I'm trying to help get
Inventory and whatnot organized at work. They are used to 5 year
budget plans that list out exactly what has to be purchased what year
and how much it will cost. Currently these are kept in Excel and look
like this
| Inventory information (who, what, where) | 2008 | 2009 | 2010 |
2011| 2012
The cost for the item is displayed in the column in the year when it
will be replaced,and summed, for department, as well as for the year.
I have all of the information on the item stored in an Access 2007
table, with the who what wheres in their own fields, and fields for
replacement year and replacement cost. What has me stumped is how to
format a report so that it looks like the Excel format I tried to show
above, without having to do a whole bunch of manual tweaking anytime
it is run, AND without having to re-export to Excel.
Is this something that I can pull off in Access? Is anyone willing to
give me a shove in the right direction?
Thanks!
Can you give us your table structure(s) please?
Everything I *think* I need for this report is in the one table.
Name * *Type * *Size
* * * * AutoNumberKey * Long Integer * *4
* * * * Asset Tag * * * Text * *10
* * * * Inventory Type *Text * *25
* * * * Assigned * * * *Text * *50
* * * * Description * * Text * *255
* * * * OS * * *Text * *255
* * * * Department * * *Text * *255
* * * * Location * * * *Text * *255
* * * * Serial Number * Text * *255
* * * * Purchase Date * Date/Time * * * 8
* * * * Purchase Cost * Currency * * * *8
* * * * Replacement Year * * * *Integer 2
* * * * Replacement cost * * * *Currency * * * *8
* * * * Notes * Memo * *-
* * * * WindowsUpdateDa te * * * Date/Time * * * 8
* * * * WindowsUpdateTe ch * * * Text * *255
* * * * VirusDefsDate * Date/Time * * * 8
* * * * VirusDefsTech * Text * *255
* * * * VirusScanVersio nDate * *Date/Time * * * 8
* * * * VirusScanVersio nTech * *Text * *255
Is any more info needed? The report will not need to include any
fields listed after "Notes"
Thanks!- Hide quoted text -
- Show quoted text -
1st Get rid of all the spaces in your field names. That is a biog no-
no is database design. It makes a lot of things (queries, code, etc)
a LOT mor complicated.
2nd Make your ReplacementYear length 4 and use the full year. (Again
it will clean things up in the query, report, etc.)
3rd As is often the case there are many ways to skin this cat. You
could build a cross tab query on The AutoNumberKey - ReplacementYear -
ReplacementCost . This will give you a 'grid' of ID - 2008 - 2009 -
2010 - etc with the cost for each.
4th Build a query on your table and query built above to create all
the other data you want in your report or excel extract then crete
whatever report(s) extract(s) you need.
Im sure there are other ways but w/o having your db in front of me
thats what I can come up with for now.
On Jan 15, 2:24*pm, LadyIlsebet <amy.s.coo...@g mail.comwrote:
I'm not a fantastic Access developer, but I'm trying to help get
Inventory and whatnot organized at work. They are used to 5 year
budget plans that list out exactly what has to be purchased what year
and how much it will cost. Currently these are kept in Excel and look
like this
| Inventory information (who, what, where) | 2008 | 2009 | 2010 |
2011| 2012
The cost for the item is displayed in the column in the year when it
will be replaced,and summed, for department, as well as for the year.
I have all of the information on the item stored in an Access 2007
table, with the who what wheres in their own fields, and fields for
replacement year and replacement cost. What has me stumped is how to
format a report so that it looks like the Excel format I tried to show
above, without having to do a whole bunch of manual tweaking anytime
it is run, AND without having to re-export to Excel.
Is this something that I can pull off in Access? Is anyone willing to
give me a shove in the right direction?
Thanks!
LadyIlsebet,
I'm almost certain we've met before, many years ago, while I was a
student at Oakland U., possibly at an event near Grand Blanc to which
a friend named Anne invited me. Let me know if there's anything I can
help you with. I don't have a lot of extra time, but I know which
side of the mouse to hold, so to speak, when it comes to Access.
James A. Fortune CD********@Fort uneJames.com
Thanks for the help! I have been able to create the basic report I
needed, and learned ALOT about crosstab queries in the process.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: booner |
last post by:
Is there any way to show an existing access database (.mdb) report inside a
vb.net application?
Any/all pointers much appreciated.
BBB
|
by: Daedalus |
last post by:
Ok I'm once again showing my complete (or almost) ineptitude with all things Access.
I'm using Access 2007 and need to do the following:
SETUP:
I have a table of membership information, and a table of dues information. They are linked via a unique ID number so that I can see the data for each entry without opening the corresponding table.
PROBLEM:
|
by: kenmasters675 |
last post by:
I need help with the following code.
I am trying to extract two reports at the same time, but I want the viewer to see the report first before exporting it. The reason is in case the report is null. There are two reports, one for 2006 and one for 2007.
Problem is when I tried making a Msgbox if statement, it does not work correctly. I want the user to say "yes or no" to extract report and then continue from there.
I can't get either...
|
by: =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= |
last post by:
Hi All,
We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007
(Office 2007) for one of web application.
This web application is using Excel (Pivot Table) reports. With Excel 2003
application (Reports) works ok.
But when Office 2003 is upgraded to Office 2007 Excel reports stops working.
It Log the error “Exception from HRESULT: 0x800A03EC.” In database.
|
by: Bhishm |
last post by:
Hi,
I am creating a attendance sheet software for inhouse use.
my data is like this:-
------------------------------------------------------------------------------------------------
| name | login time | logout
time |
------------------------------------------------------------------------------------------------
| | |
by: ttfitz |
last post by:
I have an application developed in Access 2000, to be distributed as
an MDE. For those folks without Access, they install the free Access
2007 runtime. For the most part, this seems to be working well.
However, when viewing a report in Preview mode, if you right-click and
select the "Export" option (I have defined a custom menu which
includes the standard "export" option), when using the runtime you
immediately get an error, which says,...
|
by: Bobby |
last post by:
Hi,
I'm using Access 2007. I'm opening a report using VBA as follows:
DoCmd.OpenReport stDocName, acPreview, , acDialog,
OpenArgs:=sqlString
The database is setup so that when a user opens it, they only get
limited access to certain things, e.g. they can't see the database
window unless they press the F11 button.
|
by: Brett Barry: Go Get Geek! |
last post by:
Hello,
I just started using Access 2007 after using Access 2003 for a long
time. I've created all my queries and they work fine. However, either
I forgot or it has changed but, how do I create a report based off of
multiple queries?
I tried using the report wizard using one query. In the Properties
sheet of the report, the record source for the report only shows one
query. But if I try and add another text box and add the control
|
by: Gord |
last post by:
When I open a certain report, it runs some code that generates the records
that will be displayed in that report. This works fine. When I go to print
preview the report it appears that the code is run again? This is causing
certain error problems.
1 Why does the code run for a print preview when the report already
exists?
2 What command do I use in code to find out if a report (or any other
object for that matter) is already...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
