Recent content by Evagrius

Thank You, much - I followed your direction. You're right AlexN - I really am thinking Excel. I've only used Excel for the past few years and I am having a tough time separating the two . . will keep trying.

Hello, I thought this would be simple. I am trying to divide each unique value in a column by the total column; so sales by total sales . . what am I doing wrong, please? [sales]/sum([sales])

Ahh - - I see - thank you AlexN for clearing my confusion.

I am sorry - please be patient. In the query in Datasheet view, the very last row, should sum all the above rows, but not sum the last column with percentages. Instead, I would like to divide the last row with sales by sales goals . .

arnelgp - I am sorry - I am not sure that you are directing? Can you please be more specific?

Hello - using Access 2010. I have a select query. Column one is "Zone", Column two is "Sales", and Column three is "Sales Goal". Column two and three are currency. Column four is a division of column two and three - so "sales" / "sales goal". So column four is a percentage. Where I need...

Thank You.

Hello, I have a crosstab query with a column heading of the name of the month. The proble is that when I run the query, the months are not sorted according to their natural progression. Of couse sorting asceding and descending will not work. I would appreciate any ideas. Thank You!

Bob - thank you so much . . .I don't have access to my PC now but I will try in the morning and let you know. You are the man brother :)

Hi All, I used a code to prevent the user from pressing the shift key to access the menus on the Database. I placed a textbox in a form that allows me to enter a password that would then enable the shift bypass key. Due to some error I don't understand, the form opens up blank with no...

I just built it using your tutorial and that did the trick :) I was so happy I ddidn't even look at it yet :)

Bob - I never think the wordThank You is sufficient for what you do. Your tutorial was perfect!! Thank you my friend :) Also, the db was not my own, I just received it today. Even though I am a beginner I know enough not to revert to flawed naming erros!! Thank You!

Bob - I just tested something that may give us insight. If I open the sub form seperatly, then open the main form, then the formulas work. If I open the main form by itself, even though the sub form is included in the main form, the formulas don't work. Why is this? How can I fix it?

Hi Bob, The formula in the control souruce of the textbox in the main form is =[Forms]![Date xx, yy]![txtMax_Stop_Dte] the name of the textbox in the sub form is txtMax_Stop_Dte Do you spot an error?

I tried that Bob - but for some reason when I close and reopen the db, the textbox in the main form seems to lose connection with the one in the subform . . .any suggestions?