I would design the tables in SQL Server and then maybe use Visio to document the relationships... and draw the pictures, but I'm not sure MS left that in the...

About the best you can do is once you add one field from your dataset to the tablix/matrix, then you can choose the other fields by clicking on the next...

Or you could install Reporting Services and do the reporting there... Kind of depends what kind of reporting you're doing. One thing that Access doesn't do well is crosstabs/matrix...

do it in your WHERE clause.

WHERE MyTable.MyDate>DATEADD(yyyy,-1,GETDATE())

Must be getting rusty...

FirstDelim =INSTR(Fields!TwoFields.Value,"=")+1

SecondDelim = INSTRREV(Fields!TwoFields.Value,"=")

FinalValue=CDBL(MID(Fields!TwoFields.Value,Fields!FirstDelim.Value,Fields!SecondDelim.Value-Fields!FirstDelim.Value))

So without the intermediate calculated columns:

CDBL(MID(Fields!TwoFields.Value,INSTR(Fields!TwoFields.Value,"=")+1,INSTRREV(Fields!TwoFields.Value,"=") - INSTR(Fields!TwoFields.Value,"=")+1))

The CDBL just converts the text string back into a number... only necessary if you're going to...

Alex,

Glad to help. Give it a try and post back if you get stuck. If you need help. post the CREATE TABLE scripts for the Budget and Actual...

Robert,

could you post the create table scripts and insert statements for some sample (representative, not necessarily real) data? Then I think your question would be easier to understand and...

I don't know of a way, outside of using T-SQL, to do what you want. Inner joins cause records without matches to drop out of the result set, so...

This is slightly wrong

WHERE DXCD1 IN (IS NULL, '7140')

Try

WHERE DXCD1 IS NULL OR DXCD1 = '7140'

If you create a new database in Access, it won't have anything in it. So you create a connection to the SQL Server database, and then link to the...

If you can connect to the SQL database from Access, you can link to the tables/views in SQL Server and then run a bunch of MakeTable queries in Access. ...

I would use either a proper backup script or you could right-click the database, and choose Backup... from the menu. Just to make sure you didn't damage it when...

You could create a new instance of your database, make it read-only, and then report on that. If you don't need real-time data, then that's the easiest.

You could just do...

What you do is entirely up to you. Search the jobs in your area for both SQL Server and Oracle. Take the certification exams if that's what floats...

Jeff,

If you're gonna go there, why not go to Gila Monster's Howlers - Partitioning[/url] ?