Search results for query: *

Hi Dhookom, Thnx for ur reply. I have put in all the column heading and row heading and values into my query that I need. Also some of the values in the matrix are 0 or NULL. Well if I create a report based on this query, it says cannot recognise Inquiries.ID. Hence I read somewhere that...

Hi all, I have a crosstab query based on 2 tables, 1 of which has around 13000 records. When I click on the query, the results are displayed pretty fast. I also have a select query based on the crosstab query so that NULL values wont have any problem in the report. So I try to generate a...

Hey guys, I am trying to send out emails to a list of people with some information about them. So each person gets a separate with different information each. Now the names and email ID and the information to be sent is the result of a query that I already have. I am not sure how to...

Hello All, I have 2 different tables having different attributes and attribute names. But they contain alomst the same data just that they have different names for the attributes. Now I want all this data at a common location and So I try to append the data putting similar field values...

Hi Harvestlily, Thnx for the help. It does work now. Took me a while to get used to the code module but I have it working now.

Hi harvestlily, I sound like a dumbo, but I still havent got it and wud require a brief description of how and where to put in these IF ststements that u suggested in the report. If u can plz clarify that, that wud be awesome.

Hi harvestlily, Thnx for the reply, but the month names in my report are values of a calculated field in the query. And also when I used your solution, it showed the numbers and not names.

Hello All, I have a cross-tab query which gives me monthly data in a tabular format. In the report which I try to generate from this query, I want to display the name of the month from the month number, for which I use MonthName() function. But somehow in the report it prints out #Error...

Thanx PHV, That helped. But I have another question. My table consists of First_Name and Last_Name fields, which should not have duplicates when considered as a combination, but can have duplicates when considered separate. For e.g. First Name: David Last Name: Giles First Name: Robert...

Hi All, I have a table which has around 1500 records and I dont want to go through each record looking for duplicate values. But I am pretty sure, that there are some duplicate records. Is there anyway I can delete the duplicate records from the table, leaving just 1 unique record, with...

Hi All, I am trying to build a query, which needs me to get data from 2 which dont have any relationship, based on some criteria. Here is an explanation of my problem: I have 2 tables Table1 and Table2. Both of them have a field called 'Name'. I want some other fields to be shown in...