Search results

Good Afternoon, I have a need to sum values from multiple rows (records) into one row if the following criteria is met. I have tried the group by in query, I have tried multiple expressions and am stumped. If the Fund, Location, CostElement, Department and Account are the SAME in multiples...

I am attaching a document that shows the results correctly is an easier to read format. Kim Afternoon, I am working on my 2nd union query to pull revenue data from two different sources. In one table, I have the approved revenue budget. In another table, I have the adjusted revenue...

I have two tables of budget data. EssBase Pulls original approved budget by various fields (fund, location, cost element, department and account - known as the GL String) Ex: 10-0000-4-0000000151-7300, $1500.00 (Approved budget) PeopleSoft Pulls current adjusted budget & expense by various...

Ok, I have been trying to add a calculation in a query from two tables. I have read this forum, gone through the help menu and am hitting a roadblock, so now I am requesting help. I have tables: BUDGET and TODAY'S DATE. Within the Budget table, I have a field called Expense. Within the...

Within my table if Field 1 has an answer of Self (from drop down), then, I would like Fields 6-12 to auto populate; however, if Field 1 does not have an answer of Self, then leave Fields 6-12 blank. I am not quite sure how to lay this out. I am using Access 2010.

I consider myself a basic Access user. I have built a few straight forward databases, but I have a question. I want to build a database to combine data. I want to download data out of our ERP system. I have a table with Position IDs, but no incumbents. Then I have a table that shows...

Good Morning! I am trying to put a validation rule into my table for an email address, to dictate that the last part of the email MUST be @my.lonestar.edu I have reviewed this forum, as well as others and have tried various ways. Is null or (Like "*?@my.lonestar.edu*") Is null or ((Like...