Search results

Thanks Bob. These are crop years from late september to the following (early to mid)October which is one growing year. In that year there are tasks that I hope to plot throughout each year and then compare hours/$$ over 3-4 years. (later exercise) Thanks so much for your help!

Thanks so much Bob; so are you saying I can just call the expression CY and not use iif's? Like CY: "CY" & Format([Pay Period]<=#10/25/2008,"2008",<=#10/24/09","2009") etc.?

I have been successful in joining 4 years of data through a union query (which I am very novice at) and off of that query I would like to categorize them by year (crop) and have written the following iif statement which is not producing CY08 records, they are reflecting CY09. I see CY10 & CY11...

Worked like a charm! Wonderful; Thanks so much for your help!

Thank you so much, To confirm: sum(nz([SumofGas $Amount],0)+nz(SumofDiesel $Amount],0)) Is there an "=" in front of sum? Thanks so much!

I have a detail query of all transactions for our company vehicles fuel usage. I then wrote a total query to give me totals by card which lists totals for gas and totals for diesel (separate fields). I am trying to write a sum to combine both gas & diesel for report purposes and am not doing...

The "Me.txtManager" etc; is that in the combo box or is that in the text box for operator? What I had hoped was that the user would use the Veh # drop down combo and then below the combo have a text box populate based on the Veh #. Sorry for being slow and thanks so much.

Thank you so much for your help. I want to make sure I'm clear on what I am trying to do. I have a table, Mgr Table, which includes the manager name, and the vehicle he drives so they are unique Bob V001 Tom V002 etc. The Mgr Usage Table contains the mileage; personal, business,fuel, etc. which...

thank you so very much; not quite clear on some things but will post again tomorrow as it's time to go home. First question; in the row source, is it just mgr table or do I select both fields for the row source from the mgr table? This is all new to me so please bear with me. Thanks again; until...

I have been struggling with this for two days now and am at the point I need to consult the experts. I know this topic has been discussed at nausium but whatever I try I have yet to be successful so here goes. I have a Mgr Vehicle Usage table that tracks business and personal miles of company...

I am trying to learn this as well. I have a combo box that is based off of Mgr Table. 2 fields, Manager & Vehicle #. So on the form when I select from the combo box Veh#, "V107", I would like the Vehicle operator (text box) to populate the field with the name from the Mgr Table. How would I go...

Thank you so much!

I am trying to designate a time status in a query. That everything before 3/28/11 is to be named "Pre" and everying after is to be called "Post". This is what I have written but all the records say "Post". What am I doing wrong? Thanks so much as always! Status...

Thank you so much!

Would that be in form properties? Thanks so much for the help; this is really so great.

What is the best way to handle opening the form to a new record? I have tried on the Main Form a button who's macro says to open the form but how do I go to a new record? I have tried different things and then the DMax no longer works. Thanks so much.

Did you hear me? Big shout "Awesome"! Thank you, thank you!

I am getting an invalid string error; I must be have something wrong in the verbiage. Also, should I change the type to numeric?

It is a text field i.e., V006. If it needs to be numeric it can easily be changed; I'm in the start up of this db.

=DMax("[End Hrs/Miles]", "[Vehicle Usage]", "[BCO #] = ” & Me.[BCO #]) Please,please confirm; brackets around the fields and quotes are where they should be; I don't know much about these things. Are my spaces correct? Thank you! (I know I am close)