Search results

Great links, very helpful...Thank you!

After creating a database and splitting it to back-end and front-end, where the back-end is located in our shared server, what is the best way to have users use the front end, so that the speed is not compromise, and if i need to change any of the designs also have complete control of who is in...

How can i Begin to create a query with a running total? I have the following columns Ranch_Block MeasurementDate AcreIn What happens is that once a week or so they take a mesaurement for every block and tell me the acre inches. But i want to have a running total by block for example...

Oh....ok, thank you

That You very much for the response, But how can i set all the permission and stuff?

Hi, I recently created a Database, My backend in a shared network and also the front end, but i require every user to make a copy of the front end and paste it on their desktop before they use it. The problem is that, depending who opens it, it react differently in my back-end. For...

DLookUp("[Psi Final]","Rafa Update Sheet","[R/B]= '001-03'" & " And [MeasurementDate]= #" & dtmMaxMeasurementDate & "#") Moved the ) to the end, then it worked flawlessly and it returned the value I needed, that will work, but if anyone has an idea how to combine them , let me know. And thank...

Hi, I am trying to get a text box to go back and grab the last date of info entered and then use that to do a lookup and return a value. here is what I have. This brings back the last Date that data was entered for 001-01 ( Block) Expr1: DMax("[MeasurementDate]","Rafa Update Sheet","[R/B]=...

I would have nver thought of breaking it up and first bringing up the last or MAX then looking where it matched the Rep...that was great. It didnt work but i know which way to head now...thanks so much. Once i get it i will post it back..

Hi! I would like to use a text box that would return the last value entered. I have a table that keeps the following information. Rep, Date, Product, Amount so James, 5/20/09, Candy, $20 Joe, 5/21/09, SOda, $5 James, 5/21/09, Soda, $21 Is there any way that on the entry...

Well I have done that, but it doesnt show my heading the way i want it it does it like this Date: Oct 15 Rep: Josh Product: Product A Date: Oct 15 Rep: Joey Product: Product A Date: Oct 15 Rep: Frank Product: Product A and so on, but it does not do the joey, frank, etc in the...

Hi, Is there any way i can create a report, in which the heading appear under the same group? for example: Josh, Joey, Mary, Aaron all sell Product A on Oct 15, and Paul, Frank, Joey sell Product B on Oct 18. Is there any way i can get a report with a group by date, *Then a Heading...

Actually that sounds really good, I ll try that and them ill post back what i found...thanks for your time and feedback.

well, as an example, on june 1, ranch 1 -block 1-5 and ranch 5 block 5-8 are irrigated 12 hours, then on june 2, ranch 1 blocks 6-7 and ranch 30 block 1-8 are irrigated 24 hours...etc...then the next week it might be the same or the hours can change...depending on the weather...But they make...

Thanks and i have all that done as far as having normalized tables and all that, all my primary keys, for my ranch and block stuff...and i think that would work for a table and having all the data I need....but for data entry...i think it would be kind of hard to enter a date for time it was...

Well, since i got 2 very good replies let me explain the whole process. I work for an Ag. company, and we are trying to plan a schedule for irrigation, My fields in my table are Ranch, Block, Date, and hours and a couple more thing.. Well i want to make the data entry in my form as easy as...

Hello! I have to design a table, in which i can keep a record of hours by date. so on this day they had so many hours the next day this many and so on.. but i would like to have it by month The scenario i am imagining is having a table with an option to select 1 from the 12 months then...

Thanks PBaldy! It helped me

:confused:Hello! I have a Report in which i would like to get the average at my page footing, but i only want it to get the average if the value is greater than 0.. Name Balance Jose 300 Jesus 0 Maria 250 Lupe 50 And i want it to give me 200 instead of...

So you really cant? Not all my calculations are so short i have some like this SumDQty: NZ([DQnt Standard_Ctns])+NZ([DQnt High_Pack_Ctns])+NZ([DQnt Bags=Std_Ctn])+NZ([DQnt 10/4Bags=40_Lbs])+NZ([DQnt Bags=50#&6/8's])+NZ([DQnt Snackers])+NZ([DQnt 1/2 Family_pack])+NZ([DQnt...