Search results

Hi all, I have a table of customer compliants. It currently has about 14000 records. I have also created a number of queries that summarise the data for a range of reports. I want to append any new complaints to the table to contiune the analysis. Also some of the old complaints have...

Been trying to crack this one for a while. DB attached, trying to write a query that outputs. Group By State, Count of Type A, Count of Type B, Total Count of Type, Count of comments. Thanks MQ..

Thanks, I think that worked nicely. Clicking on the SQLview now gives TRANSFORM Avg(SAP_CALD.CASE_DAYS) AS AvgOfCASE_DAYS SELECT SAP_CALD.OPN_YEAR, SAP_CALD.CLD_MONTH, Avg(SAP_CALD.CASE_DAYS) AS [Total Of CASE_DAYS] FROM SAP_CALD WHERE (((SAP_CALD.Department)<>"DPSG")) OR...

I have: TRANSFORM Avg(SAP_CALD.[CASE_DAYS]) AS AvgOfCASE_DAYS SELECT SAP_CALD.[OPN_YEAR], SAP_CALD.[CLD_MONTH], Avg(SAP_CALD.[CASE_DAYS]) AS [Total Of CASE_DAYS] FROM SAP_CALD GROUP BY SAP_CALD.[OPN_YEAR], SAP_CALD.[CLD_MONTH] PIVOT SAP_CALD.[Model]; which works fine. I want to look at...

Thanks again, I want to round the avg figure in my crosstab. The SQL code is below, but the output is not rounded. MQ

Thanks for your help. What you say does make sense. Although I don't want to assign a number because I am taking an average in the crosstab and putting in 0 will stew my results.

Hi all, I am trying to construct a crosstab that averages a calculated field from a previous query. It is returning a "Data Type Mismatch" message. The field I am trying to average is a subtraction of dates to find total days. I assume my field is not a number so I have tried to wrap it in...

Hi all, I have fields for an employee database & require an access formula to count how many days an employee was employed within a certain month A have attached an excel sheet with some sample data. Thanks for your support, MQ

Hi guys, I have a start date and end date and looking to count the amount of days within each month, the following is an example of what I have Customer, From Date, To Date, Days 1 10/02/2011 4/04/2011 53 2 11/02/2011 5/05/2011 83 and what I want my query to do separate each month and...

Not to confident on creating a scatterplot in access from 2 fields in a query. Confident on how do do this in excel but my chart has nearly 300,000 points. Anyone know any good tutorials? :)

There is around 400,000 records in the consumption table. I have actually figured it out. Thanks again for your help.

Hi jdraw, Thanks for your prompt reply and Thank you for that piece of code. It worked very well. This query only returned what I was after for 1 Master ID at a time. A great start! Is there a simple way this could be adjusted so it would return a list of all Master IDs aligned with their...

Hi there forumers. I have 2 tables one is a water consumption table with billing records. The table has a To date and From date for each record but they are random. The other table is a climate table full of data like rainfall and temperature etc.. I am looking for a query that will take...

:o Thanks all for your tips, it seems to be a problem on the end of the recipient not accepting certain file types. I ended up copying and pasting all the data into 8 separate excel sheets. Terrible I know!

Thanks for the suggestion I have tried both of these. The reciepants server will not accept such files.

Hi there, in order to send a 20MB database containing 1 table via email that will only accept up to 10MB of data. Is there an easy way to split this 1 table into 2 or 3 tables and put into separate databases?

Thank you, worked nicely.

What is the formula for concatenating text in an access query? Thanks!

Thanks Gemma, point taken. These 2 tables were from separate databases.

Worked very nicely, thanks a million!