Search results for query: *

I have created a view which consists of 4 tables with a 'where clause' and an 'order by' statement. If I then call this view and add an additional restriction -- such as 'where {datefield} = today', will the database generate the full record set with all possible dates before saying - hey I...

I am trying to query a linked SQL table date field with criteria as ' datefield <= #6/12/2001#. I am running this query on a win 2000 workstation. When run against the linked tablem, it produces no action from Access. Running the same query on an Access table works just fine. thanks in advance.

While using CR8, on NT 4.0 sp6 and SQL Server 7.0, my report accesses the database in a timely fashion. ( i know this because i turned on 'count number of records first' option ). However, it then reads approx 2000 records before delaying for about 4 minites before completing the request (...

Hi all; Is there a way to dynamically change the group otion for 'The section will be printed:' dropdown list based on values prompted for. e.g if the user selects 'monthly' for the reporting period, can I change 'The section will be printed:' to 'for each month'. thanks kaiso.....

Hi all; I am using CR8 with SQL7. My report is linked to 1 table in the database. I am creating a date range variable in my formula as such: BeforeReadingRecords datevar d ; datevar range dr ; d := cdate( DateAdd (&quot;d&quot;, -45 , CurrentDate) ); dr:= DateSerial (Year(d), Month(d) ...