Search results

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...

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...

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...

Hi Guys... I am pretty new to access, and i really need a bit of help. I am trying to place an expression into a query using expression builder. I have a column in my table called "TradeStatus" for each record (company) i want to count the number of trades where the trade status is "Completed"...

Hi, I wonder if someone is able to help me as i am completely stuck :confused: . I have built an access database which is used at work by a number of people within my team. I want to add an authorise button to the database, which when clicked will stamp the record with the date, time and also...

Hi Guys, I am stuck on a subform problem in my DB - I would like to do something but not sure if it is possible - if someone is able to point me in the right direction i would really appreciate it. I would like to set up a subform on the main form of my DB and four command buttons, then...

Hi everyone - i wonder if someone could help. I am looking to understand the VBA code that should be used for a tick box on one of my forms. When the tick box is "True" i want an OLE object (which is on the form but hidden) to be "Displayed". When the tick box is false, i want the OLE Object to...

Hi :D, I wonder if someone is able to help me as i am really stuck on this problem with my database. I have created the database in Access 2003. On one of the forms in the database, i want the "Date" field border to be displayed a different colour, dependent on how long the record has been in...