Search results

Thank you @arnelgp you have been very patient and helpful. Thats everything sorted

@arnelgp I've had a look at the form and I cannot edit or add new data. I need to be able to edit from the form, is this because its recordsource is from a query?

Thank you for the help @arnelgp and jdraw. I will post a copy of the database so its easier for you to see how I would like the format of the form. On the 'Component in detail review' (the form) I would like it to show the overall cost as a value (box in there its just unassigned at the...

Ok so this gets me a query with just the Component ID and the Overall cost But I have the same problem as before, how do I show this Overall cost in the components form?

@arnelgp Thanks I have done those changes but I now get an error stating: 'The specific field '[Component List].[Component ID]' could refer to more than one table listed in the From clause of your SQL statement' I don't fully know what this means but I only have one Component ID column in the...

@arnelgp I'm having trouble getting the SQL code for the new query to work, I cant get it to reference the query where I have the overall cost. CODE: SELECT [Compenet List].[Component ID], qry.[Component cost logic].[Overall cost] FROM [Component List] LEFT JOIN qry.[Component cost logic] ON...

@arnelgp I do apologise but which table do you mean by 'yourTable'? again I'm still quite new to access and am a bit confused Thanks for the quick reply though

@jdraw, thanks I have looked through the thread you suggested and thank you for the advice. However the field connections and relationships is not what I am struggling with. I think I over complicated the question, what I need help with is referencing a particular cell in a query (known as...

[Solved] How to reference a value from a query in a form Hi All, I'm making a form to view and update components on a project. The majority of the information is in one table called 'component list', however a component can include pre-bought parts, these pre bought parts are used a lot of...

Hi CJ Thank you for your help, you really explained it well for me. For future reference and for anyone else that may have this problem, I made a query to get the data and made a SQL code as follows: FROM [Component List] INNER JOIN [Interface List] ON [Component List].[Componet ID] = [Interface...

I am using the Component ID field for both of the relationships as two components from the components table will be connected together, this is what I am trying to show in the interface table. I will upload a picture of the data in the interface table so you can see the differences Thanks for...

[Solved] Issue with Relationships (I think) Hi all, I'm a new user to access and this forum so sorry if I don't understand reply's straight away. I am looking to do something quite specific and couldn't found any help online and wondering if you guys could help me. I am building a database...