What's wrong with this expression in a query?

[djclntn]

In a query I have:

- MNTH/YR (The month & year)
- PROJECTID
- HRS (number)
- PTERNGS: Sum([HrlyBllng]*[HRS]) (Expression)
- PTPRFT: SUM[SumHrlyBllng]*.6] (Trying to create Expression)



I want to see my Profit 6% on every ProjectID

If I cannot perform this within the same query how do I figure out my profit?

[boblarson]

This

PTPRFT: SUM[SumHrlyBllng]*.6]

would need to be changed to

PTPRFT: SUM([HrlyBllng]*[HRS]*.6])

or you would need to not have that field in your query and then use this query in another one where you can then create this new field. You can't use an ailias for a calculated field in another calculation within the same query.

[hertfordkc]

In a query I have:

- MNTH/YR (The month & year)
- PROJECTID
- HRS (number)
- PTERNGS: Sum([HrlyBllng]*[HRS]) (Expression)
- PTPRFT: SUM[SumHrlyBllng]*.6] (Trying to create Expression)
Does the .6 above have something to do with 6% profit? Are you wanting Sum([HrlyBlling]*[HRS]*0.06)?

I want to see my Profit 6% on every ProjectID

If I cannot perform this within the same query how do I figure out my profit?

__________________________________________________ ________________
Let me restate: For any record, does [HrlyBllng]*[HRS]*0.06 give you the target profit for that project?

[stevepcne]

"I want to see my Profit 6% on every ProjectID"
when you say you want to see your profit do you mean the markup value or just the profit sum?
maybe *1.06 would work.

[djclntn]

What is a, "markup value?"

[stevepcne]

a markup value is when you buy a product for $10.00 and want to mark it up 40% you would charge $14.00, $10.00 *1.4

[stevepcne]

maybe this will work ptprftsum:[sumhrlybllg]*1.06 - [sumhrlybllng]

[djclntn]

Ok,, Let's say I have 4-Projects in which I work on billing them different $-amounts(per hr) & next month I want to do a 20% markup for all of my Projeects across the broad b-- how can I accomplished this tasks?

To be fair here, I'm a beginner learner with Access. It really interest me, but I greatly struggle in many ares with understanding -- particulary with relating tables & assigning P-Key & F-keys. I spend countless hours watching tutorial videos & read about relating tables, but frustrating as it is it's not "clicking" with me which is so pissing me off with myself!

Anyway, in doing a markup with what I wrote above does it involve doing an append queury? I sort of recall watching it being done in a video...

[stevepcne]

i would suggest making a column named markup% and use it with your calculated fields

[djclntn]

In the Table or in a query?

[djclntn]

Here's another question-

If I do a 10% markup on my Projects hourly rate how do I configure it to begin (or change) at a certain time (Date)? How do I write an expressing for a 10% markup effective 12/1/2011?

[stevepcne]

you can use parameters in your query, something like =iif([datefield]>=12/1/2011,[project]*1.10,[project]*[markup%])

[boblarson]

you can use parameters in your query, something like =iif([datefield]>=12/1/2011,[project]*1.10,[project]*[markup%])

Steve: If you have dates you need to use Octothorpes.

=iif([datefield]>=#12/1/2011#,[project]*1.10,[project]*[markup%])

[boblarson]

But I would NOT be hard coding in dates like that. If you have things that are going to change, put them in a table and pull the data when you need it. So you can either store the percent with the record or you can use a method like this sample:
http://downloads.btabdevelopment.com...ileageRate.zip
which stores EFFECTIVE DATES and then applies the value based on the date of the item using the value that was valid for that date range.

[djclntn]

Thanks!

I have so many things happening right now I'm actually working on this particular task at the moment so I may be posting again at a later time. Thanx again!