Search results

Re Thank you all very much! In the end I used UPDATE PartsList SET PartsList.Price = Mid([PartsList].[Price],2,10); and that worked perfectly! Many thanks! :)

Dear All, I have an access database with a price field. This contains a list of prices in the format $0.00. As this data has been imported it is contained within a text field. I have been rakking my brains trying to create a query to delete all the $ symbols from the prices, so that then...

Re Thankyou, I've tried that and changed the SQL, so that it now reads: SELECT [About You].Residence, Count([About You].Gender) AS CountOfGender, Count([About You].Age) AS CountOfAge FROM (([About You] INNER JOIN Arrival ON [About You].[Student ID] = Arrival.[Student ID]) INNER JOIN...

Re Thank you, how would I do that? :confused:

Thank you, I just tried that but got this error message: "You tried to execute a query that does not include the specified expression '[About You].Gender="Male" And [About You].Age="Under 20 years of age" as part of an aggregate function." I presume its kicking up a fuss because I've included...

Thank you for your advice! :) Do you have any recommendations on how I may get around this? I would be extremely grateful! :)

Hello! I am trying to execute a query in Access but keep getting the following error message:confused: : "Data Type Mismatch in Criteria Expression" I have double-checked that the expressions are typed correctly and am certain that they are, here is the query SQL: SELECT [About...