User Profile

Pourya99 · Oct 16 '06, 04:42 PM

someone? anyone?

Pourya99 · Oct 13 '06, 05:27 PM

bump. Somoene please help :)

Pourya99 · Oct 12 '06, 10:02 PM

Have you run this query against your database directly to see if you get the desired result?...

Pourya99 · Oct 12 '06, 05:40 PM

Go to Start > Run and type DTSRUNUI
Type in the SQL Server connection info at the bottom
Click the [...] button at the to choose the package name. Click [Advanced]
Click the [Generate] button
To the left of the [Generate] button, you will see the command to run the DTS from command line.

Pourya99 · Oct 12 '06, 05:33 PM

SELECT DISTINCT UPPER(YourField ) FROM YourTable

This will return all of them, but they will all look uppercase in the result....

Pourya99 · Oct 12 '06, 05:30 PM

I haven't written any code to create the table. I just used the design view and dropped things in. I'm not sure where I would even put the code. I have been searching for the click event for the record, but I havent found anything regarding that. I think pivot tables work differently in data access pages than they do in forms. Thanks for your input....

Pourya99 · Oct 12 '06, 04:44 PM

Hi,

I just made up the column and table names, but would this work for you?

select OrderDate,count (*) from Orders
group by OrderDate

User Profile

Profile Sidebar

Access Data Pages, Pivot Table, Current Record

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

MS Access: Binding a Textbox to a Pivot Table Cell