Search results

I am trying to upload the DB because "Your submission could not be processed because a security token was missing". Is there another way i can get it to you?

What do you think of the idea i posted?

So this is my current SQL situation from playing the with DB a little. I have this and another query with the exact same SQL except the date field is [Maturity date] instead of [Rate Change Date]. Then i created a Union query. This has been great, except i am still have the problem of duplicate...

JDraw Thank you so much. I put that coding in, and it seems to be working. I will have to play with it more on Monday. I am sure, I hope if i need more help I can call on you. :) I am sure it needs more working, but the two queries and the union query is working. Thanks Again!

it's pretty confidential data, so I couldn't put the DB up with data, but i could possibly do it without the data. Would that be of any use? Yeah i am wondering i could do IIF statements and be able to keep all the date ranges in one query for one date field, then do the same with the other...

That is one date range, but my problem is because there are two date fields and six different ranges, i ended up creating 6 queries, i need the data to pull in "either or" fashion into the correct date range. However it need to pull into one date range and not duplicate into another. The problem...

SELECT [Loan Information].[Loan ID], [Loan Information].[Call Report Type], [Loan Information].[Maturity Date] AS [Date 3], [Loan Information].[Loan Status], "Maturity" AS Type FROM [Loan Information] GROUP BY [Loan Information].[Loan ID], [Loan Information].[Call Report Type], [Loan...

I'm not sure that would pull from two date fields. Should i create two queries each with a partition for one date field, then union the queries?

So I guess this is my final attempt to see if I can create certain results with a query without having to actually program. My query basically has a large amount of data. Each quarter we have to submit information from the data within six different date ranges: Less than 3 M 3M - 1 Y 1 Y - 3...

I am guessing there isn't solution to this, without manual programming.

Attached is a screen shot of how i have one of the queries set up. the problem is I have two date fields and I want it to use both to pull the data into each date range, but only use the data once. I also need the priority of the date to fall to the date fields with the more present date value...

The only problem i see with this solution is how i would incorporate the two date fields, and have it pick the more present date?

You understand me perfectly. The problem is i need a total for each date range. There is a currency amount associated with each distinct row of data. That is the problem, I can't figure out how to have each date range show in the same query and have totals for each of them. Should i attempt...

I am sorry to keep bothering the smart gurus of this forum. I solved my date issue. So let me do a little explaining. I have probably 12 plus queries that have a various amount of criteria within each query. The differing factor between the queries are the date ranges. less than 3 months, more...

Ok fixed my errors thank you so much... All of you Bob, Brian, and HiTech Coach

Also my data is duplicating and i need each row of data to be unique.

Thank you Brian, the query now generates... However i do not have a separate column showing me the date it chose. Is there a way in SQL or in DG to have the other column show?

ok i tried it in SQL still has error, see the two screen shots attached

Ok I have attached the image. We need this query to show which ever date field matchs the given date criteria. I am wondering i should write an expression, use a Where clause, or use a where clause and keep the date criteria in the criteria section of the query. Thanks

Bob i have the image ready, but i don't know how to upload it here. I don't see an attachment button nor when i tried to add a photo, the photos sizes were quite small.