Search results

Good Morning Everyone! Here are my questions.... 1.) I would like to be able to pull up invoices that only have months July through December. Is there a "through" expression that I can use in the criteria? The problem I'm having is that I need to use words, "January", and not dates "01/2011"...

Hello all! So I have a field that gives me the difference of 2 other fields, and it looks like this in design view: Budget vs Actual: Sum(([Actual Amount]-[Budget Amount])) In the field next to this one, I need to divide the difference (which the above field shows in my query) by budget...

Hello! I have another thread going with another issue so I thought I'd start a new one for my new issue :o My boss asked me to build the following queries: Total Spend by Vendor Total Spend by Year Total Spend by Group Total Spend by Account Monthly Spend by Vendor Monthly spend by month...

Hello all! I'm a beginner so please bare with me. I've researched my problem a dozen different ways and can't find the exact help I need so I've come here. I have a list of Vendors on an Actuals Table that will have vendors added to it from time to time. I also have a Vendors Table that...

Hello Everyone! Is it possible to have 2 or more PKs in a table? Is it even necessary? Is having 'autoNumber' as the PK good enough? Thanks, The Novice (Nani):confused:

Hello everyone! Thank God for this forum... I am not an expert at Access but the executives in my office are looking to me to build this HUGE database, so here I am, doing my best, and I've run into a problem. I have a table with the following field headings: AutoNumber, Budget #, Project...