Search results

I am looking for some helpful tips and resources from any one having experience designing applications using UML or nay other object oriented design methodology am interested in some sample design documentation and case studies. Most of the Systems Analysis and Design books do not contain any...

I am facing the same problem. After reading this post at least I know where to look for. But still I can only browse a help topic like 'Microsoft Jet SQL Reference'. I would like to be able to search on any keyword in the help topics. I am going to install Office '97 just for the...

Did you create a text box in the footer ? Also make the text box wide enough to accommodate all the digits of the number. [This message has been edited by araskas (edited 03-26-2002).]

No. It gave me correct results. I created a temp table with a Date/Time field formatted as hh:nn:ss. Then i ran this query- SELECT Table1.ID, Table1.Time FROM Table1 WHERE (((Table1.Time)<#12:22:22 AM#)) ORDER BY Table1.Time; Access changed the criteria I entered i.e 00:22:22 to 12:22:22 And...

Probably the field name in the table could be different some thing like First_Name, Last_Name. Use Expression builder in the query design to drag those relevant fields to your query. Or else create a query by first creating separate columns for First Name and Last Name.

you can have a form/subform pair to solve your problem. You can find lot of examples on using form and subform in Microsoft Solutions sample database.

Very simple. Leave your query alone. Craete a text box on your report footer. In its 'control source' property just type as below: = count(*)

You can use the following function to get the age. You can replace the function by a lot of IIF statements if you want to. If you know how to use VBA you can easily code this. Otherwise also just open a new module and paste the following code in the module. Public Function GetAge(dteDOB As...

create an append query using the query qizard. Look for some examples on using teh append query. It is really very simple.

Once you build your cross-tab query open the query in design view and change the column Expr1: "Qtr " & Format([MyDate],"q") to Expr1: "Qtr " & Format([MyDate],"yyyy/q") Where Expr1 is the column heading. [This message has been edited by araskas (edited 03-08-2002).]

Even if both fields are text fields if one of them has null in one of the records whole comparision fails. Check for not null on both fields befor you do the comparision. If you want to make sure that none of these records has nulls sort the table on each field step by step to see how many...

I undersatnd that the only thing that changed between the time you created the query and now is data. I bet there are some fields in your table or data source for your query that have null values in some of the fields ( numeric or text or both) where as your query is not expecting nulls to be...

Expr21: ( nz([Expr17])+nz([Expr18]) + nz([Expr19]) + nz([Expr20]) )/4 Search for help on NZ. it can convert null to zero and also can do many more things.

SELECT Type, IIF ( Type = "LapTop" , " " , [Processor]) AS Processor1, IIF ( Type = "DeskTop" , " " , [Make/Model]) AS [Make/Model1] FROM myTable;

You have asked for a really complicated query. Here it is - Assume your tables are Site{ Sitename } Product{PName, MSite, Pite } I am mot using any SiteID or ProductID fields. I am just doing direct string comparision. SELECT Site.SiteName, Product.PName...

use DISTINCT clause. SELECT DISTINT cName, cID FROM myTable; Type this in SQL window and you will not see any duplicates.

In the query woindow goto SQL view ( use View- SQL View ) . Then paste this text into the SQL view window

It is a simple query. Use In clause as below- SELECT Table1.* FROM Table1 Where Cid not in ( SELECT Cid from Table2 );

You could use 2 queries as below - Query1: SELECT Max(myTable.ColA) AS MaxOfColumn FROM myTable UNION ALL SELECT Max(myTable.ColB) FROM myTable UNION ALL SELECT Max(myTable.ColC) FROM myTable UNION ALL SELECT Max(myTable.ColD) FROM myTable; Query 2: SELECT query1.MaxOfColumn as...

The following co-related sub query will also do the same for you . SELECT DISTINCT Outer.Fund, Outer.Price, Outer.Date FROM myTable, myTable AS [Outer] WHERE (((Outer.Date)=(SELECT max(Date) FROM myTable1 WHERE Fund = Outer.Fund ))); Take a look at this - FROM myTable, myTable AS [Outer] For...