Search results

Hello, This is my first try at creating a database and I need help with my report format. I've a attached a picture of how I need the report to look like along with my db file. Any help would be appreciated. Thank you

Is there a way to setup the report so that Original Budget, Committed Contracts... are columns and the $ amount of the entry shows under the approrpiate column for each entry? (see attached example)

@DBinPhilly, did you delete your post for some reason? I got an email that said you posted the following but when I came to see read the post I couldn't find it.

I'm not planning on doing this but it peaked my interest, what feature do I need to lookup to learn to do that? Also, did you get the chance to fix the report in the sample you uploaded? (General guidlines on how to achieve it would be great if you don't have the time)

Didn't think I'd need to differentiate by job# (this project is a small test-run for me) but you're right. I'm going to revise the database. Thank you!

@jdraw Thanks for the tutorial, printing and reading. I tried doing what he said and failed so I asked about another method, I appreciated his help at first but when it became sarcasm it stopped being help. I don't know the design principles so I'm trying to find them out, but all documents I...

@lagbolt Category is the CSI masterformat categories I have listed. Type is consist of whether it's a budget entry or cost... I read about Table normalization, thought mine were. @DBinPhilly Thank you for the example! I guess my mistake was that I didn't have one table that contained all the...

Well that was downright rude... FYI I tried using subforms and I didn't know how to make it work. I'm reading Crysal's guide on sub-forms, a reading that was suggested in another thread on this forum. Meanwhile I thought I'd try using queries to fix my problem. If you're against people trying...

How about this idea, I can create a query that has all the fields I need for the form and I can base the form on it. I tried doing that but data entry is messed up.

Thanks for the input, all the data is accounted for, the other fields will be just sums of the data I have in Basic Table. I created the form using the form Wizard and selected the fields I wanted from the 3 tables that I have. I then opened the newly created form in Design View and deleted...

Working on Access 2007, I'm building a new database to track cost in construction. I have a working template of it in Excel but I decided that I would benefit from the queries available in Access to get more out of my data. This is my first time building a database, so I did some reading (e.g...