Recent content by lovelykid23

Thanks a lot. Because they are still on the update so I have to keep 2 tables seperately.

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...

Where can I add them? Can I do this with macro? Or I have to write a code? Thanks,

It is by record. And it is ok if next time I open the form, the counting reset from 0.

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...

Yup, I know that line is ridiculous :confused: I'm new to Access and slowly learning along the way. I never use Module before, but I'll look it up now to see what I can do with it. And yes, I use Val() because the [Test Kit Result] is stored as text, not number. Besides all the legit numbers...

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...