Search results

Thanks guys. That is working great. I have never used a union query before, but it works beautifully. Thanks again, sam

That worked on that part, now how about this? There are dates in all four tables, in a query how would I group all those dates into one set of dates? I can't sum or any such thing. Any suggestions?

I keep trying that, but I am getting empty cells back, no data? What's that mean?

Here is the exact problem, after I put all the data in one query and use totals to group the four different groups into the 12 months of the year, how do I then group them all together under 1 group instead of 4?

I have 4 databases that I am pulling the same table from. They have the same fields with different data. I am needing to group on the similar dates and sum the totals. I have a query setup where I have all the data summed but it is not combined yet. I am having problems combining the data. Can...

Thanks, I will give it a shot.

Jon thanks for all the advise. I will give it a try. The problem with changing the data types and such in the tables is that all are linked to another database that I have no control over. We are not putting any data into this system but only pulling it out. I hope that helps so that I don't...

You think I'm killing you...? This mess only gets worse. Anyway...the query does work and the date grouping works, what is happening is that the data that is summed in the query is not calculating correctly. If you look at the sums2 query and look at january "h" it should be 1620 and it's not...

Jon- I am running into a problem with my data not being valid when I use both queries. Any suggestions? The dates group, but my fields that are summed are too large.

I have a query and I am trying to basically use the data from the line above on the active line. Is this possible?

You are a genius. Thanks!

I apologize I do care about the year also but I would like it to look like this: January '02 (Sum of some numbers) February '02 (Sum of some number) ... Possible?

That example is exactly where I am at also, so can we do this, I would like to group everything in January under one "January". Just like you can do in excel basically under a pivot table. Maybe that is my solution is to just use a pivot table. What do you think.

That would be great if you could do that. Thanks, Sam

Ok, still not fixed. I would like it to group the dates into the month. It is splitting out and telling me for every date I have what month it is in. I have it in a query with most fields set to sum or avg. I tried datepart() and it just thought it was a string. Any suggestions?

Here is what I ended up using: Format([DATE],"mmmm"), but I cannot get it to sort correctly. Does anyone know what happened?

Thank you that worked!!

I tried just putting the month and not even doing the year, but I keep getting a data type mismatch error because some of the dates are null.

Here is the problem I am running into now. In the query if I don't have the date field in there I am getting an error message of "data type mismatch" and if I do leave it I cannot get it to group and sum correctly. Here is the calculation I used. WORK: Left([DATE],InStr([DATE],"/")-1) & "/" &...

Great idea. I will try that