Search results

This will do what you need http://www.access-programmers.co.uk/forums/attachment.php?s=&postid=101818

Thanks for your help the both of you. geoff

I've inserted the following into my query now it won't work, and comes up with the error "Microsoft can not find the name 'Present Date' you entered in your expression DMax("[Cost_Per_Unit]","[Invoice Recharging (External) Costs]","[Company] = [Forms]![Invoice Recharging (External) Invoice...

I have two tables one has the following fields TABLE1 Name Type Date M1_Present M1_Previous The other tables has the fields TABLE2 Company Utility_Type Invoice_No Invoice_Date Date_From Date_To Invoice_Amount I also have a form which contains two combo boxes, enabling the user to select the...

Thanks Rich, But I got the following to work, I think it's a lot more straight forward Right(Trim([Lookup_Name]),Len(Trim([Lookup_Name]))-InStr(1,[Lookup_Name],"- ")-1) Thanks Geoff

It's the way the database was originally set up and I can't change it

Why do I need to use an update query all I want to do is return a value of every thing to the right of the "- " so it can be used for a search criteria

I have a field which has records which all look like this Resource Centre Electricity - Name of Department What I want to do is strip out the bit containing Resource Centre Electricity leaving me with just the Name of Department I know I need to use Instr and Right functions but I just can't...

Come on guys I know there is someone out there who can help me with this. Please

Hi I tried using the following sql that i found in another thread but I keep on getting syntax problems any ideas Thanks Geoff SELECT [Recharge All Sites (Current)].[Faculty Name], [Recharge All Sites (Current)].[Actual Batch Date], [Recharge All Sites (Current)].[Actual Cost], SUM([Recharge...

Rich, I am completely confused where and how do I use this to create my Graph Thanks Geoff

the easiest solution would be to create a report and set the running sum property from the fields property box. Look at running sum under help.

I know that using DSum in queries is not a good idea but it is the only thing that will solve my problem. I have 2 tables Table 1 - Departments Field 1 - Department Name Field 2 - EACCode Table 2 - EACStore Field 1 EACCode Field 2 Batch Date Field 3 Actual Cost The query I have is as follows...

I've got it to work but not using dlookup I created a query showing the current years consumption and added a field with Target Date, I then created a second query with the previous years data. I then created a third query made up of the first 2 queries and added a join between the Target dates...

thanks for your post, but i'm still not having any joy. any other ideas thanks geoff

Here is a little more info, I have a query which has 2 fields, BatchDate and ActualConsumption. What I need to do is add a 3rd field to display the TargetConsumption, which is the ActualConsumption 12 Months Beforehand Example BatchDate 31/05/02 Actual Consumption 10000 TargetConsumption 9500...

Hi there, I could really do with someones help with the following, as I just can't get it to work. Target Consumption: Dlookup("[ActualConsumption]","EACSTORE","[BatchDate] = DateAdd("yyyy",-1,[BatchDate])") Thanks Geoff

i think you need to put hashes # either side of dates

To reference a main form from a subform Forms!MainForm!FieldName

the way I got around this was to create a delete query with the criteria being the primary key field on the form. then on the close button if they don't want to save the record it will run the delete query and delete the current record or else it will just close the form