cfrance1
Last Activity: Jul 15 '07, 09:01 PM
Joined: Jul 14 '07
Location:
-
Oh Now I see Why you are the Leader. THis worked out just like I wanted it. I'm more of a stock guy but this coding stuff is kind of addictive. Now that I have the answer I'm just gonna stare at this to see if I can figure out where the problem was. I also noticed that in my suppliers table, now, there is a plus sign next to the records and when open them I see each book that corresponds to that suplier. It's Proffesional looking I like it. Where... -
WHen I try DSum("[UnitsInStock]", "[Inventory Book Total]”) in the denominator of the expression I get this error message:
"You tried to execute a query that does not include the specified expression '[SumOfUnitsInSto ck]/DSum("[UnitsInStock]", "[Inventory Book Total]”) as part of an aggregate function."
I have tried a bunch of different things. But it always asks me the Inventory...Leave a comment:
-
I understand what you are trying to say in remedy one. THat my denominator has a source [Inventory Book Total] but not my numerator. Thats because the source of the [SumOfUnitsInSto ck] on the top part of the equation is the actual query I am trying to put the [SumOfUnitsInSto ck]/[Inventory Book Total]![SumOfUnitsInSto ck] AS Expr1 into. Can I use the open query as a source for an equation within the query?
ANd in remedy 2 I've found...Leave a comment:
-
I copied what you sent me and put it in once I saw it in design view, I realized that I had tried that already. And when try and run after adding the source, what you gave me, I get a message that says:
"You tried to execute a query that does not include the specified expression '[SumOfUnitsInSto ck]/[Inventory Book Total]![SumOfUnitsInSto ck]' as part of an aggregate function."
The query I am trying to run...Leave a comment:
-
Enter Parameter Value Error Message
Hello,
I recently started working with access for a school project in my Information Systems Management class. I'm a Finance major so it's not like I had to get this deep into this stuff, but I have a wondering mind. I put together my table and proceeded to creating my queries and they all work fine but one. I have read forum after forum trying to figure out the solution to my problem but no luck I could do without this query but after...
No activity results to display
Leave a comment: