Search results

Hi guys, I am trying to set a default date on a text box that is bound to a table. Is there any way I can get that to defaul to todays Date if its blank? i tried setting the defauls in the default value in properties but it comes back blank.

Hi guys, I have a query with the followinf information ID Days 1 4 2 10 3 16 4 12 5 7 6 10 7 20 I would like to create a report that shows me the max and its related ID, the Min and its related ID and just the Average, how can i do that?? I have a feeling...

Hi guys, I have a form which has a summary or information I want. Ranch, Irrigation Date, Irrigated Hours, Gallons Per Minute, etc. From this FORM i created a sub form, that list all the blocks in that ranch and adds the data already in the first form. I figured i could set me textbook to...

Hi, Background: I have 2 tables, One of them has a list of APN's and its description and the other table has the information about period when those APN's have been paid and what kind of tax it was. Ex: APN Table: APN, County, Owner,Acres 123 Fresno Juan 10 546 Tulare Bob 20 879...

Hello, I have an autonumber i would like to store as a 4 character number For example Autonumber [ID] 1 make it 0001 I tried changing the format to "0000" but when i do that and then try to use the Autonumber column i lose all my 000 for example if i want to add 084567 to that id i would use...

Hey, I am trying to separate all the characters in the odd number positions. for example i have 2001234567890 and i want to retrieve 2,0,2,4,6,8,0 I been trying to use mid, but i can only get 1 at a time, any ideas?

Hello, I have a formula in excel that I am using to come up with the check digit in excel like this: =MOD(10 - MOD( SUMPRODUCT(MID(A2, {1,2,3,4,5,6,7,8,9,10,11,12,13}, 1) * {3,1,3,1,3,1,3,1,3,1,3,1,3}), 10), 10) where A2 is equal to 2001234567890 after the calculation i come up with =9 I...

Hi, I have a table with about 700 records that i need in a number sequence of 4 digits ex.0000 i would really like to use the auto number function to create the numbers but I don't know how to do it. If its not possible to do it in the table i would like to do it in the query, is there an...

Hello! I have a query in which i have about 200 customers and a couple of other details, I would like to get a combo box or something similar to pop up when i run my query to allow the selection of a customer.. any suggestions and ideas will be greatly appreciated. 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...

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...

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]=...

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...

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...

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...

: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...

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...

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"...

: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...