Currency Querys???

[sugar05]

Hello All,

I'm only fairly basic when it comes to Access, and I need some help with a query. Im running Access 2003 on XP Pro, and my current database is in a one to many relationship with Staff and Activities. A part of the Activites field involves the expenses of that particular activity. I have a field in my Activities table saying total expenses. The expense formats are in currency (including total). When I go to make a query, I'm using the following critera for the TotalExpenses field. "FoodExpenses"+"OtherExpenses". However, when I go to run the query, it tells me that there is a data type mismatch in the criteron expression. I changed the field formats to text and it will run. Can access 2003 support currency based querys and if so how? It would be really handy to know.

 

[RV]

As for your criteria, use FoodExpenses+OtherExpenses

RV

 

[sugar05]

thanks. i just tried that and im still recieving the same error

 

[sugar05]

Ok. I just created a new query from scratch. Here's what i've got:

Field: TotalExpenses
Table: tblActivities
Sort: Ascending
Show: Yes
Criteria: "FoodExpenses"+"OtherExpenses"

I tried to remove the quotations but access puts them back when I click off the field. When I run the query, i get the error mentioned above. However, when I change the critera to RegistrationExpenses+TravelExpenses the query will run, but with a total of $0.00. Yes there is data in the required tables.

 

[x0reset]

It sounds like you are trying to create a calculated field, but are entering the calculation in the "criteria" section rather than the "field" section. Try entering this in the "field" section of the query:

Total Expenses: [FoodExpenses]+[OtherExpenses]

 

[sugar05]

Thankyou very much x0reset. Thats exactly what I was looking for. Your help is much appreciated.