Recent content by scottmfitzge

Excellent! Thanks very much for your help!Cheers, Scott

Hi - I wonder if someone is able to help. I have two seperate fields in a query that I would like to 'compare'I would like to know if there is a way of being able to enter a 'condition' of somekind into the query to remove records, when the entry in each of the fields is the same.Thanks in...

Works perfectly - Thanks for your guidance. Cheers, Scott

Work perfectly... Thanks for all your help!

Hi - I have created a report, which shows some currency amounts - in the properties for this value, the format is "Currency" which means the value appears as £23,983,938.00 however, I don't want the £ sign to be shown. I want the value to appear as 23,983,938.00. If i have no format, it appears...

Thanks Bob, I will take a look, Have a try and let you know how I get on.Cheers, Scott

Thanks. I can use this option elsewhere in my DB, however I would like to know how to do Step 1 and 2 from 'DCrake's' example, as I think this would work better as I will have to run a number of reports, and using this option will mean I only have to enter the start date and end date once. I...

Hi - Really sorry but how would I go about creating the append query? I am pretty new to Access so would really appreciate some steps that I could follow to do this. I also don't know how to run a field update as advised by 'GalaxiomAtHome'?Cheers, Scott

Hi David - Thanks for your advice - the document you pointed me to, is most helpful, however would you be able to provide me with some additional guidance, as i am unsure of how to perform step 1 (creating two variables in the startup module) and step 2 (creating two new functions)? - This is...

Sorry.. I am really new to this, how do i run an update on the new field. I have created it, but need to run the update. Also i am going to be adding large amount of data at the beginning of each month, do i have to run this update each time, or can i have it so that it updates when i import the...

Hi... I have created a report to show a particular date range of data. When i run the report, i am asked for a start date and end date. I have achieved this by adding the following simple expression into the report query underneath the date field: >=[Start Date] And <=[End Date] This way i...

Hi Guys... I need some help pls. I have a very large data table, that contains a date field. However the date has been stored in a particular format: 20090602, and the field is highlighted as a Number in the field type properties. I want to change the field type to Date and change the format to...

Fantastic.... Works perfectly.. Thanks!

Excellent - It worked perfectly - Thanks for all of your help Khawar... One very last question. In my calculations for percentages in my report, using the below expression, in some scenarios i get a return value of #Num!, which is correct, but instead of showing #Num1 i want to show either a 0...

Thanks for all your help... How would i change the espression: sum(iif([TradeStatus]="Completed",1,0)) If there was an additional condition that the "Product" must be equal to SPOT? Thanks