Search results

Even if 'Table'is a reserved word if you enclose in square brackets it will be treated as object name. For example you could use [Emploee Info Table] . I would say next time you name your tables use something like this - Emploee_Info_Table or in Hungarian notation tblEmpInfo.

Use 'DISTINCT' clause. Search for help on this and you will find plenty of examples on it. SELECT DISTINCT(myfld) FROM myTable ;

If you post this question in the Forms some one will help.

post your query and I will be able to help

Can you re phrase your question ?

SELECT Year([DateInitiated]) AS [YEAR], Month([DateInitiated]) AS [MONTH], Count([DateInitated]) AS [Count] FROM myTable GROUP BY Year([DateInitiated], Month([DateInitiated]);

You can do it many ways. One of them using NOT IN SELECT ID, Name, address FROM [Clients] WHERE ID Not In ( SELECT [Client].ID FROM [Client] WHERE conditionOfQry1 ) ;

Use a where clause to filter out all but one record. Example: UPDATE myTable SET myTable.myfld = 'abc" WHERE (((myTable.myPkeyfld) = 001));

If [Date1] is a field in the table you need to use UPDATE query not INSERT. Then no need to use IIF. UPDATE myTable SET myTable.Date1 = #mm/dd/yy# WHERE (((myTable.Date1) Is Null)); Example : UPDATE myTable SET myTable.Date1 = #2/2/01# WHERE (((myTable.Date1) Is Null)); If you are using a form...

This is what I found using sub queries. Let Table be MyTable and numeric field be MyData. SELECT Max(MyData) AS SecondMostMax FROM MyTable AS T1 WHERE (((T1.MyData)<(SELECT Max(MyData) FROM MyTable T2 )));

You have to make the two SQL statements part of a transaction. Look for help on Transaction . You can find plenty of examples on that.

Union qry is not needed here. Qry : SELECT COUNT ( IIf(invoiceType = "A' , 1, 0 ) ) AS [Count Of Invoice Type A], COUNT ( IIf(invoiceType = "B' , 1, 0 ) ) AS [Count Of Invoice Type B] FROM MYTABLE [WHERE 'any Where condition here'] ; Let me know if it does not work. Alternatively you can...

I solved my problem. In case any one is interested in knowing- I used the oldvalue property of the text box control.

I have a form with calendar control on it. I call that form from all my other forms. If my sub form is in datasheet view I call the calendar form by using double click event. For all other forms I created a button and call the calendar from the double click event. After selecting the date the...

My tables are customers (1-many) with Orders, Orders ( 1- many) with OrderDetais I have a main form (frmMaincustomers) with 2 synchronized subfroms (subfrmOrders, subfrmOrderDetails). Order Detail has a field called Shipped Date. I want to display the maximum (shipped Date) from...

I want to use a calender control on my form but at the same time I do not want to clutter my form. Same form is used for view,add &update operations. I would like to morph the calender control to a text field when not in add mode. Any tips ?

CREATE TABLE myTable (fld1 LONG CONSTRAINT myKey PRIMARY KEY, fld2 TEXT .....)

The record selector displays the unsaved record indicator when a record is being edited. Is there any use other than this ?