I have an Access database that has checkboxes in on of the tables. I need to get a Sum of the checkboxes but, I want to convert the checkbox columns into rows instead of columns. Here is an example …
Tag: ms-access-2013
Create aggregated SQL report where the columns are based on a table list
Not sure this is possible but I’m hoping someone can point me in the right direction. I have a database that audit logs when a record changes stage. What I need to do is consolidate this back up into a report that gives me the earliest audit record for each stage by Record ID. i.e. I end up with a
concatenate columns based on blank columns
I am having three columns,- and / should be used as separator result should come in new column(File Index-sub Index/Year),if sub index is blank then result should be (File Index/Year). SELECT [ …
Combine the results of multiple queries into one table
I have a table that gets its entries populated through a form in MS Access 2013. I have attached an image of part of the table below. Using the StartTime entry, I created a query that displays all the transactions that occur between 8AM – 9AM, and another query to display all the transactions that occur between 9AM – 10AM,
Join query in Access 2013
Currently have a single table with large amount of data in access, due to the size I couldn’t easily work with it in Excel any more. I’m partially there on a query to pull data from this table. 7 …
Data type mismatch when using a Select Query to feed a combo box
I am getting a ‘data type mismatch in criteria expression (error 3464) with the below routine when trying to activate drop down box ‘cboColleagues’. In short, there are two combo boxes of which the second one (‘cboColleagues’) is not visible until the user activates the first (‘cboEditPersonnel’). The following routine is created to feed the second combo box with the