Search results for query: *

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...

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...

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...