Search results

due to sql added in second reply

have a query which contains two tables linked with table1 and table2 imte master ( table name ) IMTE NUMBER( field name ) monthofcal( another field name in table1 ) asd101xyz jan asd101xyz jul asd102xyz jan asd103xyz jan...

thanks for the reply i will upload my db tomorrow as iam out of office thankyou i have a query which contains two tables linked with table1 and table2 table1 ( table name ) suppliers( field name ) months( another field name in table1 ) asd101xyz jan asd101xyz...

i have a query which contains two tables linked with table1 and table2 table1 ( table name ) suppliers( field name ) months( another field name in table1 ) asd101xyz jan asd101xyz jul asd102xyz jan asd103xyz...

i have a form in which i have fieldname [resultnumbers] which is having the data Example : asd100xyz ,asd101xyz ... etc i have inserted a " Microsoft Office Spreadsheet 10.0 " in the same form when the record is " asd100xyz " i should have details for that record in the excel sheet and if...

CBRIGHTON SORRY my reply was before i could see your path way to the solution i got it when i followed your latest reply and got 1210 records updated in two minutes to a new field thanks for spending TIME, MONEY & BRAIN TO HELP ME

cbrighton thanks i got the solution for the table but now the problem is i have stored the data in field whose data type is text and contains 1210 records if iam able to transfer this data to a new field name as [monthofcal] and data type as date/time and in form format i will give only month...

brainwarnock i got your reply and it worked thanks for the solution but i have i problem now i have 1210 records which have only jan,feb,mar.... till dec data how will i be able transfer this data to a new field and use your trick so that i can use this * <= Month(Date()) * in the criteria of...

thanks cbrighton and Brian for the reply iam still weak in access i am learning now can you pls tell me how to do it, because i dont really no how to do it in a query or using vba code or in a form

i have a field name [monthofcal] and it contains data type as text and i store value like jan,feb,mar.... till dec. but the problem is iam not able to retrive this for calculation purpose like this <= Month(Date()) what should be the data type so that its value should be jan,feb,mar...

thanks for your help vbaInet and brain warnock i actualy want only month names in the field dont want day and year if i give date/time in table datatype field it is asking for longdate, generaldate etc so iam not able to put to data type date/time field or iam not able to understand your...

thanks for the reply vbainet i got it working

thanks for the reply VBAINET as you say design is poor how can i change my table to store only month like ( jan) not as day month & year (01/jan/2011) o

i have a query which has two fields one is "months" and other is "status" is it possible to get data column wise "months" ( jan,feb,mar....) and row wise "status" ( good, better, best ) these are the months field items months : jan feb mar apr may jun goodsum: 10 5 3 12 16 11 ( sum...

iam using in a query which has field [month] containing jan,feb,mar.... till dec for this [month] field the " data type " in table is " text" because when i open the query name " till this month " i want it to show the month names till current month that is till "oct" and should not show nov...