I don't know of any built-in functionality, but you might want to look at Access Analyzer from FMS (http://www.fmsinc.com). I used this in the past and I thought that...

I would definitely go with your first option. Even if the second option has faster performance, I just see a maintenance nightmare as reports are modified or new reports...

jonathan allen-270981 (11/16/2009)

---

Guys,

Rather than get over concerned about collation for choosing the character to replace the 2nd space you can use any string, so you could use

SELECT LTRIM(RTRIM(

...

Try this:

INSERT INTO qsum ( coa, desc, quant )

SELECT '399999' AS coa, 'Total' AS desc, Sum(qsum.quant) AS quant

FROM qsum

WHERE (qsum.coa Like '3*');

I just realized that there shouldn't be quotes around Username:

select UserID, dbo.getUserName(UserID) as UserName

from User

order by

(case when @sortorder = 1 then CAST(UserID AS varchar(50))

when @sortorder = 2 then dbo.getUserName(UserID) END)...

Yes, I missed that. When I tested it, I used two varchar columns. I suppose that you could wrap a CAST around the UserID like this

select UserID, dbo.getUserName(UserID)...

Try this:

select UserID,dbo.getUserName(UserID) as 'UserName'

from User

order by

(case when @sortorder = 1 then UserID

when @sortorder = 2 then dbo.getUserName(UserID) END) desc

Scott,

I think that you could gt it to work as a modification of what we've done before, but, assuming that this isn't a homework problem, I'm thinking that it would...

Scott,

Glad to be of assistance. I've never had a situation like that before and it was good to figure it out. Good luck with your project.

Steve,

Thanks...

Scott,

Here's my code:

CREATE TABLE [dbo].[Cities](

[CityID] [int] IDENTITY(1,1) NOT NULL,

[CityName] [varchar](50) NOT NULL,

CONSTRAINT [PK_Cities] PRIMARY KEY CLUSTERED

(

[CityID] ASC

)

)

CREATE TABLE [dbo].[Users](

[UserID] [int] IDENTITY(1,1) NOT NULL,

[UserName] [varchar](50) NOT NULL,

[CityID] [int] NOT...

Steve,

I think that the OP misstated the relationships. I believe that there is a 1:M relationship between City and User and between City and Area so City is at...

I suggest four tables: User, City, Area, and UserCityArea. I would put a city column in the User table. You will then have your 1 user to 1...

The code I had was to strictly run a stored procedure. Unfortunately, I've never tried to return a recordset from a stored procedure. Here's some info I copied...

I've used an ADODB.Command for this. Here's a sample that I've used:

Dim cmd As ADODB.Command

Set cmd = New ADODB.Command

cmd.ActiveConnection = CurrentProject.Connection

...

Glad I could help and I don't think that was a stupid assumption on your part. Keep learning and soon you'll be an expert. Someday I might be...