The "Lookup & Relationship" field is referencing another table for its values. Access 2010 allows a lookup field to have more than one value selected. My problem is that when I use this field in an access query I am not able to link the lookup field to another table because of it is considered a...
Is there another field that can be used beside the lookup field in an Access table? I am currently using the lookup field as a multivalued lookup field and I am limited to the the things I can do with it when creating a report or a query on that field. Is there a similar field in Access 2010...
I am trying to create a report that links a table with another table using the web query. I want to use a multivalue look up field from one table and link it to the ID in another table. My problem is that Microsoft Access won't allow me to do this. When I try to create a report without using the...
Is it possible to create an embedded macro in a report?
I want to be able to click on a value in the current report and have it open another report depending on the value that is selected; however, when I select the column I want to use to create the macro on I am not given any options to do so...
Are there limitations to the expression you can enter in a report. I have tried entering an expression as the control source for one of my reports and it works perfectly in Access 2010. However when I sync with my SharePoint site and open it in the browser I recieve a sql error.
This is the...
Are there limitations to the expression you can enter in a report. I have tried entering an expression as the control source for one of my reports and it works perfectly in Access 2010. However when I sync with my SharePoint site and open it in the browser I recieve a sql error.
This is the...