Search results

Hi - I am trying to create a crosstab query to attempt to replicate a Pivot Table in Excel. I want the cross tab to look like this Work Description Condition Code Cost of Work Building 1 Replace windows B £20,000 Building 2...

Hi, I have a linked table in Excel which is the source for my data. When I review the contents in the Access Table - it all seems fine and the formatting of dates, currency, numbers with commas etc all matches the Excel spreadsheet. However, when I change into Form View, some of the items...

Hi - I have a current table which is linked to excel. In excel I have a column which contains a hyperlink to a specific folder for each row. In Access I want to have this hyperlink on a from so that each record has a link which points it to a different folder on my drive. In the design view...

Also - I want to include a photo in some specific forms. I can add a picture in design layout but this then applies that picture to every record. How do I get it so it's unique to each record? Also - is there any way you can create a link to a network folder on your pc? For example I want to...

Hi, I am trying to run a report on some data that I have in a table. The report looks something like this Break option date Property Landlord 1 A 2 B...

Hi everyone - just joined the forum. I am from Scotland and am an absolute beginner on Access. I use Excel a fair bit but have never done any coding before so apologies in advance for all the basic questions!!! I work in commercial property and am using Access to set up a database to store...