Hello,
I am working on a simple webpage to track and edit assets. I have the database and the basic code out of the way so that I can have one page that will display every asset and information about it.
I would like to be able to switch to a department view, where, obviously, each device in the particular department will be displayed. I would also like to be able to display a total count of each specific model number.
This is ran on an Access database. I have been messing around with Access trying to figure out how to make, say, a table for each department that receives it's data from the main table (the one that includes every single asset). Is there no simple way to just make a table take data from another, the way you can reference cells in Excel?
I set up a query to count each model number. That was fairly simple, but how do I force that query to spit that data out into a separate table? Or is it possible to use ASP to display data in a query the same as it would from a table (know what I mean?)?
Or, instead of making Access do all of the work, which just seemed easier to me at first, can I filter for certain data in the database using ASP and display only the rows that would contain a cell that reads, DEPARTMENT A or DEPARTMENT B? Something like that?
I hope I posed my questions good enough and didn't make them too confusing.
Topic Options
Post Options
Thanks(0)
WebWiz-Bruce wrote: