Hi David, Rather than running an export for Access to Excel, and then getting others to sum columns, try this single query that should do what you...

Hi, All my query: PARAMETERS DateTime, DateTime; TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks SELECT AS Badge, Sum(Master.AmtVl) AS SumOfAmount,...

I am trying to do crosstab query that with a unique PO# count, but unsuccessulf. How do i run this query to count the PO# and group by customer? Right now...

I would like to have crosstab query and only needs to tranform without calculations. I just wonder that should all crosstab need formular like count, sum, max...

I have a call log with a time stamp and a buyer name. I want to make a form based on a crosstab query that will give me a table with the count of calls logged...

Hi, All I have table with a few fields of user's activities, it looks like foloowing: IsDate IsTime Id Unit Activity Code 5/1/07 8:00 614 01 ...

Hi all, I have following sample data from a Crosstab query: PRODUCT CODE Q1 Q2 Q3 Q4 TEST1 01 10 2 TEST1 ...

I am trying to make a query that has Rig1, Rig2, Rig3, Rig4 on the top.. Category 1-15 down the left side and the Totals of each category for that Rig under...

I am frustrated with this one... I have a crosstab query used to display results on a graph. I want to filter "risklevel" depending on what is selected in a...

Hello- Is there any way to combine the results of multiple crosstab queries into one report? One post I read suggested temp tables and union queries. Some...

I have a table with five columns the first three are text the last two are numeric. I have five rows of data in the table. I set the values in the first...

running access 2k; don't know why Xtab queries seem to be SO hard to understand.... BUT... I have a REALLY simple table: contact_ID call_date 1 ...

Hi, I had tried to do the following in order to get the column headings in a crosstab query to appear with different names -- other than the default: 1....

I use Access to run my pool league. I am trying to get if not a crosstab query, some query whic will give me one team's wins vs. another team. Right now I...

Hi, Struggling badly with this and would appreciate some help. I have 20 different sales items and I want to monitor the weekly total sales quantity of each...

Hi All, I have a db which records referrals sent into the office. Data entered onto the db includes the usual name of student, school name etc, and also...

I am attempting to display the results of a query in a datasheet view to my user, but in a "spreadsheet" method...The view I am looking for is exactly like a...

Hello I have 2 tables 1 Members ID FirstName LastName 2. Stats EntryDate EntryType

OK my brilliant pretties Riddle me this The fields: IncidentDate Region Agency CareItensity IncidentCategory IncidentSubCategory

Hi, I have a database that keeps track of the varios committees that each person is on each year. Now I need to build a table with people's name as...