Search results

I have a table that has three columns: Nationality, Gender, and Date. First I had the problem of grouping the Nationality column by Gender. That i resolved by creating a crosstab query. Now, I want to put a criteria on Date field so that when the query is run it will ask for the date input and...

I posted this question in "Reports" section and here I am posting the answer. Because I think it is more related to "Queries" than reports. I have a table that has two columns "Nationality" and "Gender". I wanted to run a query that will Group the nationality and then split the gender column...

I am migrating a database from Spreadsheets to Access 2010. Everything else is going well but I am stuck at one point. A table has Name, Gender, and Nationality fields. Now, I need a report that will have only Nationality and Gender fields. The nationalities will be in a list and another column...

I am using Microsoft Access 2010. It provides great filtering and sorting options in the ribbon for any object. But what if I hide the ribbon and want to create custom buttons on the form to do the filtering and sorting job? There are some filter options available in macros but are not quite...

I have a simple and small database having only one table. I want the data table to be exported in a spreadsheet format automatically at the end of the month. Is there any code or function to do that?

I am working at a clinic and I am given the task to create a simple and small database for patients coming for a specific test in a certain department. The clinic has its own database software application but for some security purposes the data of this department is not linked to that system...

Hello There! I am a I.T. enthusiast and professional. I am working as a Computer Network administrator in a small business company. I am currently residing in Riyadh, Saudi Arabia. My home country is Pakistan. I have plenty of knowledge and experience in General Computing and Computer Network...