jcrew10
Last Activity: Mar 20 '14, 09:50 PM
Joined: Mar 5 '14
Location:
-
I am very appreciative that there are folks, like everyone who has posted, that are willing to give a beginner a chance. Great forum folks! Thank you so much! -
Thanks everyone, I am understanding more of what's happening with the tables. I had not thought of it in those ways so I am very appreciative of everyone's input/advice.Leave a comment:
-
I made a new table (called LinkedTable) that has all the stores rolled up. I did this by doing the SQL query per Galiphraen's suggestion. I got the data to roll up. Now I need to sort the data where I can have some calculations populate when that store and date range is selected. Thanks every for the information so far!Leave a comment:
-
Well this all started as a separate location type database. Each location (5 total) has their own dedicated database because all locations would need to input data at the same time (COB) so it was structured to prevent folks from not being able to save data. Users are not computer savvy. That's why all the tables have the same field names but just are different table names (This is what they are used to from their hard copy). The data is similar...Leave a comment:
-
Report with multiple Linked tables with same type of data.
Is there a way to do a report that gets information (data from tables that have same field names) from 5 different tables? I don't know much about databases in general but have this problem. I have 5 different locations that have the same exact data tables (different names) but I wanted to roll up that data in 1 report so I can get calculations done. Is there a way to do this? Using access 2010.
No activity results to display
Leave a comment: