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] ?

Sounds like you need an outer join between Sales and Budget instead of an inner join. Post your query so we can see what you're dealing with.

I can't answer your question without some CREATE TABLE scripts. What table are the records related to Customer coming from?

I posted a basic pattern based on AdventureWorks because it's...

If you add /x:Macroname to the end of the execution path, then when the database opens it will call the macro Macroname, so you could have something like

DoCmd.RunSQL...

Application.Quit

inside your macro...

maybe like this?

SELECT *

FROM test_max m

INNER JOIN

(SELECT id

, MAX(date_created) AS LastDate

FROM test_max

GROUP BY id) lst

ON m.id=lst.id

AND m.date_created = lst.LastDate;

You may want to add your fields explicitly to your SELECT...