Search results for query: *

Top" does not appear as an option for update queries.

Using Access and need to limit the number of records updated to 1000....the "limit" function appears to not be acceptable to access....how can I do this? thanks in advance!

I use a field in 36 different formulas. Is it possible to mass change the field name in the formulas without having to open each one up, change the field and save?

Ahhhhh...thanks!

I have a table that resembles this: RECID ITEM COST 001 ALPHA 5.00 002 ALPHA 6.00 003 ALPHA 7.00 004 BRAVO 3.00 005 BRAVO 4.00. My report is set up so that the output is the last record for any given item. I do this by hidding the details and putting fields in the...

Thanks for all the info. Would this work? Could I create a view that retrieves the records from multiple databases and then base the report on the view? Troy

Is this better than Crystal for report authoring and distribution?

Crystal 11 Developer version connecting to sql databases generating reports from crystal

Is is possible to create a crystal report where the user can select the database on the fly? I have 10 databases with identical tables names and structures. Each database represents data from a different company.

Is there a way to specify the size of the page without being limited to the size of paper that the printer can accept. I am trying to create a report that will always be exported to excel, but I need more room to work with in the layout.

Is it possible to create a pass through query that uses prompts so that when the user runs the report, the user is prompted and the query uses the parameters input? (I'm using a pass-through because I need it to be read only) Troy

Is there a way to keep pages with no data from printing in FRx?

When using a reporting tree, is it possible to get FRx to not print the company name on the report?

I understand why you say that, but I'm dealing with a database that was already constructed when the project was passed to me...i recognize that if i were allowed to change the database then my problem would more or less go away...but i can't...

How can I prompt a user for a field name and use that name in the update query...ie...the tables in question have 12 columns, one for each month....the colmuns are named 01, 02, 03 etc....i want the user to input the appropriate column name have the query update just that column...Thanks in advance

Thinking about buying FP...a couple of questions: 1. Can database results be presented in 2,3 or more columns instead of the standard 1 record per row...i.e. an ecommerce site that lists the products in 2 columns instead of one? 2. Can FP "build" or populate a page on the fly...ie if a product...

How do I create a prompt in a query that allows the user to select the value from a list? T

Does Peachtree have the ability to generate Purchase Orders from Sales Orders because an item is out of stock? T

I need to pull data from 2 tables. I have current year data in table A and prior year data in table B, hence, the field names are identical. I need to be able to input a date range like 1/1/2003 through 6/4/2004 and get all the records that meet that criteria. There is no relationship between...

I am trying to create a macro that copies data from all the files in a directory to a file called costs.xls. But my macro keeps trying to open the same file. Your help is appreciated. Listed below is what I have. Sub DirLoop() Dim MyFile As String, Sep As String ' Sets up the...