Search results for query: *

Usually when someone posts field names that are incremented - you posted FlightAmount and FlightAmount1 - it means that they have some normalization issues. If you have a table somewhere that is set up like this: my_table --------------------------------------------------------- some_id...

Probably nothing to do with your error message, but surely you want to throw some "()'s" into the equation to help properly evaluate the calculation? Also FlightAmount, FlightAmount1, M&IE, M&IE1 gives the impression that you may have some normalizaion issues that may not have direct bearing on...

Ok, just to answer your last question, it is possible to print out a form that has been filtered. But, I'd like to make something clear first. Your original post gave me the idea that you had a single table with some information that you'd like to filter in various ways to see various results...

Use the form wizard to create a form based on your table. A simple tabular form should do. Then go to records/filter. The simplest filter is a filter by selection. Say you wanted all the records that were blank for a field called name. You just rest your mouse in the name field where it is...

I think your best bet would be to create a form based on your table and then apply filters at will. -Tracy

You say that you have the Oracle University manuals, does this mean that you took a few courses? Go to http://education.oracle.com/ to see what is available. The user manuals are big but they are complete. If you find them too daunting, you should at least skim them to familarize yourself with...

If you're looking for the Access syntax for a make table query it is: SELECT Table1.[field1], Table1.[field2], Table1.[field3] INTO my_table FROM Table1; or SELECT Table1.* INTO my_table FROM Table1; This of course differs from the actual sql syntax for making a table which is: create table...

How about: where G.Flg != true or where G.Flg <> true -Tracy

LaurelLee- If you don't understand the existing queries, etc, then start by looking for the data in the tables. You want a history of holds. Look at the tables to see if this data is stored somewhere. It sounds like you have some code to put a project on hold. It sounds like your current...

You can get that by using this: SELECT year, Count(year) AS CountOfyear FROM your_table GROUP BY year; But I suspect this is not what you want since you say you want a query to look at a query. If you post more details, you'll get a better answer. -Tracy

Josselin - Go to this url: http://otn.oracle.com/documentation/datamart.html and download this document to give you an overview: A68055_01 PDF Oracle Data Mart Builder Getting Started Release 2.5 -Tracy

Nevermind, I see you double posted and a solution was provided by BNPMike.

Glen - I'm guessing this has something to do with the 'group by' that you're using with the sum. Can you post some sample data and the group by part of the query? -Tracy

I'm sorry, I'm not a VB expert either and I don't understand how or when the code you posted is being executed. Also I'm confused that you originally asked for a method to display two different reports but are now asking about displaying the client sums in a form. If you want to display sums...

It sounds like you need to create two separate reports since you desire the display of the 'All' results to differ from the display of the 'Individual' results. You don't say how you are calling the report from the form. If it's just a command button, then a simple solution would be to add...

MAM8512 - the short answer is to create a query to join the two tables and select the fields you need for the report. Then base your report on the query. Look into the running sum property for your report. As your question differs from the one posted on this thread and the original poster...

dimmech - I was just suggesting an alternative which would be to add the foreign key customer_id to the prospects table to help you to identify prospects that were already turned into customers. If you are happy with the direction that you got from bhoran then you should go with that. If you...

How about if instead of deleting the records from the prospect table, you added a customer_id when the prospect is converted to a customer? This would keep you from re-adding the already converted prospects to the customer table. -Tracy

dimmech - in the previous discussion, it seems as if you are deleting records from the prospect table after they are appended to the customers table. If this is so, then why would you need to test to see if the customer already exists before you do the append? Is there a chance the customer...

I'm not sure if you can use the wildcards with NOT IN. Try this: Where Fieldname Not Like "*TEAM" or Not Like "TEAM*" or Not Like "US" -Tracy