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 created a cross-tab query and it solved the problem. selected the nationality column as row header, gender column as column header and customer Id as calculation point. the SQL code looks like this: TRANSFORM Count(Register.[Customer ID]) AS [CountOfCustomer ID] SELECT Register.National...

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

well, thank you very much..it worked, report has nationalities in descending order.. a snap of the report can be seen here imgur.com/HxFB33U and the SQL command looks like this: SELECT Register.National, Count(Register.National) AS Total FROM Register GROUP BY Register.National ORDER BY...

Seems the thing i need, but donno how to apply it...do i have to make a query or something? a little light on the matter will be apreciated.. thanks

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 have removed Primary Key from File Number field, so the user can enter any file number he wants and thus can start the number from 1 for new month. I couldn't understand your last comment: "set the file ID criteria to the form's current file ID". i donno what that means, could you please...

How do I create a query that picks up certain (not all) information from the current record on active form? and then how do I open the report that uses the same query to print the said record?

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