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...

Plog, Thank you for the information however, either I was not clear or there is a misinterpretation of data. I will review your information to see if it will be helpful. Please note the following however. DWNLD_Essbase_Hyperion_Revenue ONLY holds the Approved Budget, Dept, Fund, Loc and...

Plog, I am attaching my expected results in the attached, as I cannot figure out how to insert an excel table or pdf into the body of the message. Kim

Paul, I attached a PDF after I realized it posted weird; which is easier to read. Kim

a Union Query worked for this. Thanks!

I ended up using a Union Query. Results have been confirmed. Thank you both for your input. Kim

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...

MarkK, thanks. Your information helped! I rethought how I was handling this and put the equation directly into the expression and that fixed it. Kim

The join is on the academic year... Here is the SQL SELECT TBL_Departments.[Department Name], DWNLD_OV_Budget.Fund, DWNLD_OV_Budget.Location, DWNLD_OV_Budget.[Cst Element], DWNLD_OV_Budget.Dept, DWNLD_OV_Budget.Account, TBL_Accounts.[Account Name], DWNLD_OV_Budget.Budget...

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...

We use this database to track our veteran student certifications for Chapter 33 benefits regarding tuition and fees for the college. It was established with one main table to house the certification data and numerous queries so that we can pull the data out a number of ways. We recently had...

what specifically? This database is setup with one main table and several secondary tables that are used with Combo boxes. There are not really any relationships established.

Thanks...love the video; however, apparently I was not clear on what I am trying to accomplish. Let me try again. One Table - called Data Within this table, I have fields: FirstName LastName DOB Then, I have fields: Vet? - which is a combo box associated to another table with...

I am using a Native db

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...

Thanks everyone! Got it working. I appreciate the help.

Still ended up with an error "Existing data violates the new setting for the "Validation Rule" property for the field, but if I say accept anyways, it posts the majority of the records...still working on it. Any other ideas?

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...