Hi there! Using A02 on XP. Not a programmer but learning. I have some data that I'll be exporting to a comma delimited (.csv) file and would like to update...

When I type a filter in the query design for 5154* it returns Alike 5154 and does not work although 5154 exists in my database. If I type Like "5154"...

Hi I need help in some calculation. It is easy in Excel, which I used to do. I have a table with multiple fields including stimulation (text), replication...

In order to run a test, I need to split one list of records in 1/2 to create 2 equal (but random) lists.

Greetings, I have a table that has multiple fields Two of the fields are status (number) and tdate(datetime). so records would be like: 2 1/15/2005...

Is there a way of generating a CONDITIONAL UNION for instance SELECT PRO_ID, PRO_NAME, PRO_VALUE FROM PRODUCT WHERE PRO_NAME="RULER" IF (SELECT COUNT(PRO_ID)...

While merging labels, A complete data is not merged Eg: out of 800 records only 447 records are selected in any order. I have checked all fields to clear...

Is it possible to find what quarter of the year a given date is in? Any help will be appreciated. -- Hanksor Oregon City, Oregon "Mine is not to wonder, is...

Hej! Har en fråga, har en querie där jag skrivit i criteria Year(Now())-1 Or Year(Now()). När jag kör frågan får jag upp info om en medlem för året 2006 och...

I've looked everywhere to find out how to do this but I couldn't figure it out. I need to take a table and where the TG_ID is the same but has different NPA...

Ok. Here is a query that I am working with: SELECT X.id, Y.year FROM program AS X LEFT JOIN financial AS Y ON X.fin_no = Y.fin_no So basically I am looking...

Hi I have table where that I want to remove about 5,00 records. All this records contain an investor_code The records I want to remove are records with...

Hi, I need to build a query that collects information about the most current revision only. For example... Base Revision Date A A ...

Hello, I work for an insurance company and I need some professional help. I have two tables one call "Claims" the other "Reviewers" In the "Claims" table I...

I need to modify my query below that uses 2 tables (06_statments and Directory) We get the statement table from the university, they identify users...

I need to do a comparison query based on a field that sometimes contains 12 characters and sometimes contains 13 characters. I need to ignore the...

Hello, I have an extracted list of US zip codes and their longitude and latitude. I want to use this data to restrict the sales area of a product. For...

I have created a form keeping track of "Clients", primary keyed by SSN. Another form was created to keep track of "Client Cases" each time a client comes in...

I'm not even sure how to phrase this for a search to see if it has been answered before. I have a query that identifies results in a table with two pertinent...

Hi, I've Orders and Agents tables joint in a query. The Agents table has AGENT_ID and MNGR_ID. The query pulls the monthly orders per Agent. Some Agents have...