Recent content by cdr1869

SELECT [N/E Deliverables].[Deliverable ID Tag], [N/E Deliverables].[Budget-to-Deliverable], [N/E Deliverables].[Invoice1 Amount], [N/E Deliverables].[Invoice2 Amount], [N/E Deliverables].[Invoice3 Amount], [N/E Deliverables].[Invoice4 Amount], [N/E Deliverables].[Invoice5 Amount]...

I believe this is what you're asking for?: Budget Remaining: [Budget-to-Deliverable]-([Invoice1 Amount]-[Invoice2 Amount]-[Invoice3 Amount]-[Invoice4 Amount]-[Invoice5 Amount]) I've made some changes: I took the (#) sign out of my field names for ease of entry in the code. What I need at...

Im sorry. All of the original field names and the ones entered in the query calcualtion are static: Invoice #1 etc. I just mistyped it here...

I'm having some trouble entering the exact code I need to deliver the results I'm looking for. I am using MS Access 2007. For my query, I have Deliverable ID: Primary Key/Constant Budget-to-deliverable: $$ Invoice 1 amount:$ Invoice 2 amount:$ Invoice 3 amount:$ invoice 4 amount:$ Invoice 5...

I could not find a thread on this so if this question has been posted and answered already, please just point me in the right direction... I'm using MS Access 2007; Windows 7; My question is: I have created the swtichboard and organized it how I need it to be however, the main label (label1...

Hey all, happy to have joined this forum, I hope that I can learn a lot of tricks of the trade as well as help some people out too. I've been using Access 2007 for a very short time ( 2 weeks) but I jumped in the deep end and I'm still afloat ( so far :)

I have been using Access 2007 going on...2 weeks now and have been charged with the task of creating a database to track projects, their related budgets, deliverables, completion etc and make it user friendly to data entry. I have Access 2007 for Dummies as well as I've gone through all of the...