Search results

Quick question! I have a query in which im calculatins some fields Total: [Value1]*[Value2] is it possible that in the same query i can use the "Total" again? Percentage: [Total]/100 I can make it work, but right before i run my query it ask to "Enter Parameter Value" Do i have to make...

In the statement below, CCur(NZ([Party Payments].[Advance Bill Value],0) Are you telling it to come back as zero if the value is not set to currency? and do all of your fields have the same data type?

Alright! Thank you guys a lot... In case anybody else needs something similar in the conditional formatting you have to go into Expression is and then your criteria.. It makes so much sense now...

This is a different option rather than a solution...create your own switboard...basically its a form with a lot of buttons that can take you where ever you want and at the same time you can customize it... Just a thought..

I just have to say thank you!....this page has helped me so much and I will do as much as i can to help maintain something like this up

HI I have a cell that i would like to get it highlighted if the value was not "12" or "24"...I have Field Value is not equal to 24 in my first condition but i cannot put Field calie is not equal 12 in my second condition because it highlight everything... So i tried putting and "or"...

Thank you a lot, i have to test them but once i get it working ill post my results and my opinion..

Is there a logic why Iif works but not IIF? I kept ketting an error until i changed that, but it doesnt make sense why......

If you have doplicate data in your first table connecting to your second table, wouldnt it be a many to many relationship? Are you able to enforce Integrity rules?

:eek: Hello! OK, I havo to calculate some fields based on a wage or rate of pay and keep a history of it. So during a time period, this person worked so many hours at this rate and the year later rate of pay went up and so on. How can i calculate fields in a form so it goes back to a table...

Do you have a unique ID for every record in your main table?

Make sure that they copy your front_end database and put it on their desktop, if all you tables all linked correctly it will run very smoothly....

Smeghead...thank you very much......

:confused:Hello, Once again i have a question! ha! Ok i have a report with has a page heading, then i have heading for my different groups..with there are about 3. So on my page i have my title and my other headings, then below that i hace a heading by Ranch,then under that i hace a...

I just began using access...so i have a lot of question and a very basic understanding of SQL all the database management stuff...but im really good with excel.....ha!

*Clap* *clap* Awesome... thank you..i changed that and added it on the form, then it worked.....

well i could, but i need to get information from another table and that table to calculate my field.. in one of my tables I have A block ID, the APN #, the gross acres and the number of trees in that block on my other table i have a Block ID, variety, year planted and spacing between trees...

Thank you Smeghead But i know that the issue is the calculated field i added, is there any ways i can make it work even with the calculated field?

Hello! ok here is my new dilema.... I have a form comming directly from a table..everything works great I can add or delete rows....well now, i go into the properties and record souce and connect it to another table, to be able to have the necessary information to create a calculated...

Got it!!!!! =DLookUp("[Diameter]","Emmiter Matrix ","[Emitter] ='" & [subform T_Rch Blk Details].[Form]![Emitter ID] & "'" & "And [Pressure]= [PSI Final]") I had the Emmiter ID coming from a subquery which was connected by a ranch and block... but the thing that was killing me was the & and "...