Search results

I have two tables and two query created based on the two tables. Then I created 2 reports, each report based on a query. The columns in two tables all have the same name. They are just different types of data. So the 1st report is built based on Query1 and the 2nd report is on Query2. I created...

Hi guys, I have a Form to input data into my table. Sometimes, the data needs to be duplicated exactly so I added a "Duplicate Record" button. I was wondering if there is any way to count the times I click on the Duplicate button (so I know how many times the data was copied)? So like every...

Hi guys, I'm moving my office Excel file to Access. The excel file has a few 'report' tabs that give overview of the database. I need to re-create these reports in Access as closely to the ones in Excel as possible. Along the way, I have a problem with a gigantic report table in Excel. It looks...

Hi guys, I'm using some functions to build a report for my database. However, I got stuck at this one function. So I created an unbound text box and add this function. Technically, there are 6 groups of data: Home, Business, Daycare, School, Health Department and Other. These are divided...