Search results

well... i am novice here.. i uploaded my db. pls. help me writing the query i want to select the comodity and click the button to view the specific column. thanx

thanx supercool i what like that... pls. tell me where i should store the values... in a separate table?

thanx for the reply...but i want something different... riceprice wheatprice maizeprice are different columns... i need to show the specific COLUMN....

hello friends... back in business after a long time... I need some help to make a simple (?) query. I have my table as follows: monthid month year riceprice wheatprice maizeprice 1 jan 2007 350 450 340 2 feb 2007 355...

Hello there... I have a data set as follows: Product CompanyA CompanyB CompanyC .... CompanyZ aaa 2.3 2.4 2.5 bbb 3.4 - 3.1 and so on... The value represents the price of products... I want to make a query...

if your accounts are same in both tables there's no way to repeat... check your queries; in 1st query put column as account number - total as groupby, and put another column for actual - total as sum. in 2nd query put one column as account numbe- total as groupby, and put another column for...

I was reading the threads related to bypass issues... Now I know how to disable (or enable) shift key of a database with password using the code provided by ghudson: http://www.access-programmers.co.uk/forums/showthread.php?t=51479&highlight=bypass In other thread he provided another way to...

As you designed... I am not getting the idea why you made two different tables... anyway for your case... you have to make a query for actual amount group-by account... make another query with the table budget and the query of actual amount that joined by Account... However, It would be better...

You may use an update query...

? why not using a query?

I don't know whether it will help... You can split your database; put the table part in the server; Program part in your computer (link all the tables in program part - using my network place) in this way you can do anything distributing the program part in all network computers...

Use a Union query or, create an update query that will update data from table 1 to table 2

alternatively, if you are not familiar with using code, you may create another table like: id txt 1 Yes 2 No 3 N/A and make a query with your main table that joined with this table with the field ID...

more clarificaiton required... in the table the last field is not required as you can calculate it in a simple query... how you getting duplicates??

I have tested the following code, it locks the field t1 except the last record... You may try and/or improve it... Private Sub Form_Current() If id.Value < DMax("[id]", "[YourForm]") Then t1.Enabled = False Else t1.Enabled = True End If End Sub (in the table remove the ID default value as 0...

You can do it many ways, if the yes no is a check box then put following code in AfterUpdate event. Private Sub Checkbox1_AfterUpdate() If Checkbox1 = -1 Then [field1].Enabled = True [field2].Enabled = True Else [field1].Enabled = False [field2].Enabled = False End If End Sub --You can add as...

Make a query with the following SQL: SELECT tblMain.Address, tblMain.Purchaser, tblMain.Plot, tblMain.Bedrooms FROM tblMain WHERE (((tblMain.Address) Like "*" & [KeywordForAddress] & "*")) OR (((tblMain.Purchaser) Like "*" & [KeywordForPurchaser] & "*")); --you may add more fields in the...

Are you doing this just to get the idea ? You have to put all the dates as ("11-May-05", "12-May-05", ...... , "10-Apr-06")

Including this???!!!

You may try as follows: TRANSFORM Sum([Table1].[valu]) AS SumOfvalu SELECT [Table1].[id], Sum([Table1].[valu]) AS [Total Of valu] FROM Table1 GROUP BY [Table1].[id] PIVOT [Table1].[date] In ("1-Jan-06","2-Jan-06"); etc. etc...