Search results for query: *

Yes, the Main_Form is open and the EndDateTxt is populated with a date. The query works fine when I run it. The only time i get that error msg is when I export to a Text file.

Hi, I'm trying to export a simple query to a text file. However, it gives me a "Too Few Parameters. Expected 1" error message. The query works fine when exporting to other formats, ie, Excel. I have a date parameter that pulls from a form. I'm using Access 2002. Below is my query: SELECT...

I use a parameter to filter on the date field. I do have a form with a calendar, so the user can choose the date from there, but I'm just using the parameter for now. I did explicitly enter the Column Headings into the Crosstab properties. Here is the SQL View of the Crosstab: TRANSFORM...

I have an Access 2002 report that pulls from a Crosstab query. The report works fine if I don't filter on any fields. The problem occurs when I add a filter on date (start and end date) in the Query Builder. When I add this date filter, the Field List values on the report disappear. Any idea...

Thanks PHV! The code worked perfectly!

Thank you all for the quick responses! The codes from r937 and PHV were the ones I was looking for. Thanks again!

I want to be able to see the Country and City with the top 2 highest population. Country CITY Population US NEW YORK CITY 500 US VIRGINIA BEACH 200 US CHARLOTTE 400 US LONG BEACH 600 CHINA HONGKONG 800 CHINA BEIJING 700 CHINA SHANGHAI 600...

How do I get the top N based on 2 groups in Access 2002? For example, I have the following fields: Country, City, and Population. I want to be able to see the Country and City with the top 2 highest population. Country CITY Population USA NEW YORK CITY 500 USA VIRGINIA BEACH 200 USA CHARLOTTE...

Hi, I am using CR XI and am wondering if there is a formula that calculates the Business Days (excluding the holidays and weekends) from Current Date to a date that is in a dynamic database field. I've seen formulas that calculates the business days, but you have to hard code the holidays...

Hi, I am using CR XI and wondering if there is a formula that calculates the Business Days(excludes the holidays and weekends) from Current Date to whatever date is in a database field. I've seen formulas that calculates the business days, but you have to hard code the holidays. Your help is...

Thanks for the quick response. It's Excel Version specific. So, I guess there is no other way to export the lines and boxes? Thanks.

I am using a Crystal XI and am trying to export my report into Excel. The problem is that I have lines and boxes on the report but they will not export into Excel. Thanks.

The Replace() function works perfect! Thanks IdoMillet!

Hi, I have a report in CR XI that prints a memo field and the quotation marks are showing up as &quot. Is there any way to convert that back to show as " "? Thanks.