Replies

It worked.

Thanks!!!

Kinda answered my own question.

My IIf statement worked fine once I turned on the grouped by.

There were multiple deliveries of material for certain work orders and it needed grouped by to work properly.

Thanks!

Thanks for your help.
I am able to get the price to show up on the report, but only when I do something (click or try to enter a number) in the P1 text box.
I have the calculated field and the textbox keyed so that if there is no quantity there will be no price shown (if then else).

How would I be able to tie it all together?
This is my statement:
=IIf(IsNull([q1]),” “,(([material cost]+([Labor1]+[Labor1]*4.4)/[q1])/[Margin]*100))
changing the q #’s and Labor #’s up to 10.

Thanks for your help.

I know that this is an old post, but this explanation helped me alot to get the form correct.
I am working on getting the quoting program that we use in Excel into Access so that recording the quotes will be easier.
However I am having trouble getting the calculated field (now copied to a textbox) to :
a. “stick” to the data entry table
b. show up in the report that must get printed
The two of them are probably related. I have the calculated field named “Price1” (thru “Price10”) and the textbox which copies the value as “P1” (thru “P10”) I have the control source of the textbox as “=Price1” which works fine for the form. Do I need something (macro?) to have (make?) the value “stick” to the data entry table? I think that once I get this solved the value will appear in the report.

Any help would be appreciated.

Thanks,
Mark

Thanks for your input.

It seems like the best way to do this is to do it manually.
The territories shouldn’t change that often, if at all.

Thanks again for your help and advice.

Mark

Its Access 2.0
I checked Access 2000 and the suppliers form has changed.

In the Access 2.0 Northwind database, the suppliers form has the supplier (name, address, phone, fax) info in the detail and in the form footer it has a option group with toggles/buttons for each letter of the alphabet (and an “all”). Hitting a button filters the suppliers by the letter pressed.

Just thought it was a nice feature and wanted to add it our to our customers and suppliers form.
I’m having trouble getting the buttons to work properly.
I copied the form and the macro over and tried to convert it my needs, but I can’t get it to work right.

Thanks,
Mark

Thanks for your help.

I tried what it suggested. I checked the XLstart folder and that was empty. I then checked to see if the “Alternate startup file location” is entered and it was empty.
Then I checked the add-ins. I had about 12. I unchecked them all. I then closed Excel and re-opened Excel to see if the problem was still present. It wasn’t! Then slowly re-checked them – each time re-opening Excel to see if my problem came back. It didn’t.
Now I have all the add-ins checked and it starts up fine.

Dunno why , but its fixed.

Thanks for your help!

Mark

Yes I have tried that.
I also went to the Microsoft Office folder and clicked on Excel.exe.
And I got the same thing.

Thanks,
Mark

Thank you for your help.

Now it highlights the last & and says “Compile Error Expected; expression”

Thanks again.

Mark

Thanks.

I do have Publisher.

I’ll try the Publisher forum now.

IT WORKED!!!!!!!!!!!!!!

Thanks alot !!!!!!

I just had to do a little minor tweaking and it works the way I want it to.

I thought that I was doomed!

Thanks again,
Mark

Thanks for your help.
However, unless I did it wrong, it did not work.

I added the line where I should and it didn’t make a difference.
It didn’t matter if it was ascending or descending.

But, in design view it is correct.
Does that mean anything?

Thanks,
Mark

To follow up….

I went to the Microsoft Knowledge Base and found an article that may help. (Q141235)
The article talks about how to change the SQL to change the chart’s sorting order.
Here is the RowSource SQL to the chart report.

TRANSFORM Sum(qryQuoteHistoryCountperWeek.Quantity) AS Quantity
SELECT qryQuoteHistoryCountperWeek.Week
FROM qryQuoteHistoryCountperWeek
GROUP BY qryQuoteHistoryCountperWeek.Week
PIVOT qryQuoteHistoryCountperWeek.Year;

Is there a way, modifying the SQL, to make the week number be in proper order?

Thanks,
Mark

It worked!

Thanks alot!

Mark

Thanks fot he reply.

In this Access database, there is a schedule for the shop and that has a dollar amount and it shows the dollar amount when printed.

still

Mark