Search results

oh, I get it, so my question would be how can i populate and existing blank record with a default date?

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.

Like you said as long as I dont have 2 numbers with the same amount of days it works by doing two different queries, one for max and one for min to get my ID. SO thank you it works for now.

Oh so i can do that, but how can i create a query that will show me the max # and also the recordrelated to it? Im thinking i should have a where clause or a join or something like that?

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

Thank you! It worked I'm so grateful for this forum!

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

banana you have been a great help, thank you.

well actually its not in a table its in a query, let me show you all i need to do with it... 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)...

You open like 1000 doors for me with that, like something cliked..haha this is what i did to be able to get it in the query without having to go into the code stuff NewID: [Company Prefix] & String((4-Len([ID])),"0") & [ID] Thank you!

Thank you that does give me an idea where to go...

Im sorry, but how am i suppose to use that in a query? or even in my table design?

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

Thank you! I got it!

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

Thank you very much, Well i wanted to do it in a query, because i can export to excel, where we need..but i will do it on a form, thank you,

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,