Search results

Well, I have the first table already since I use it in a few other queries. It's the function I need help with. I think I can figure out the function itself, but I have no idea how to call the function to create the table. Any suggestions?

I hope this is the right description for my question. I am trying to build a table which contains the permutations or combinations of different groups. It needs to show all the possible combinations available. I have this done in Excel pretty easily and have imported it into Access for now...

Thanks for the link. What I'm having trouble with is finding if a date range is within another date range. For example: The customer has maintenance from Jan 1, 2008 through December 31, 2008. Comparing that to each quarter in the year and confirming they have maintenance. Does their...

I hope this isn't a duplicate request but I couldn't find anything in my searches. I need to show when a customer had maintenance on a product spanning numerous years. They may have dropped maintenance and then restarted later. I have a [Maint Start:] and [Maint End:] field in the table which...

Really? This seemed like a basic concept, no? How disappointing. Well, at least I know why I can't get to display correctly. :) Thanks!

I can only seem to get it to 'reverse-engineer' a single layer of the query. I can get it to pull the query into the diagram with all the fields listed, but it never pulls in the queries which fed into the final query. I then went into one of the sub queries and pulled it in separately but it...

I have searched the forum and have found a few relevant threads, but honestly I don't understand their answers. The question is this: How do I use Visio 2007 to diagram an Access 2007 query? I have some complex queries (some have sub queries and others use results from separate queries) I...

I think the code was too long for the message. Here it is in .doc format. Thank you again!!

Thanks. It was a syntax error on my part even though I can't remember what it was right now. I went ahead and tried a different route. Using your idea of "Not In" I tried "NOT EXISTS" in the sub-query. It almost worked accept it would take FOREVER returning any results. I then decided to do...

I'm getting a "Query is too complex" error on the above code. I think I need to do the second part with a sub-query, but that is still pretty confusing to me. I'm going to try a few things to troubleshoot.

I'm troubleshooting the code. It looks like it makes sense but I have one question. I didn't know 'not in' was valid sql (I know soooo little). Did you mean 'not in' literally or is there a function/command I need instead? SELECT [Monitor Account Status].FY, [Monitor Account...

Yes. If the customer has remained out of maintenance for over a year it is very difficult to get them back. Only the recent customers have a chance I think.

Also, I found a work around for the problem but it is VERY VERY sloppy. I created a second query and had it find all the customer numbers where there was 'Yes' in the Maintenance field. I then created a third query which showed all the accounts from query1 which did not match the customer id...

All the customers on this sheet had maintenance at the beginning of their purchase life cycle. The 'Current' field only reports if their maintenance is current. The customer will renew their maintenance every year (perfect conditions). Last year's purchase will change the status to 'No' and...

Here's the query: SELECT IIf(DatePart('m',[Invoice Data].[Invoice Date:])>10,DatePart('yyyy',[Invoice Data].[Invoice Date:])+1,DatePart('yyyy',[Invoice Data].[Invoice Date:])) AS FY, [Invoice Data].[Geo1:], [Invoice Data].[Invoice Quarter:], [Invoice Data].[Maint End:], IIf([Invoice Data]![Maint...

I'll try this right away. Thank you. I haven't put the results in a table yet. I only listed the results of the query. I don't like using query results to build a table in order to use them in another query. But sometimes I'm forced to since I don't have a lot of experience in Access yet...

Please help....if it's even possible :) I need to know what customers had maintenance but no longer do. I have my query working correct but I don't know the next step. Currently I have a query which searches for a specific product, tells me the purchase date as well as when their maintenance...

Thanks. It seemed too simple so I had to check :)

I'm doing a simple query to pull some transactions out of a table which fall into different ranges. In the first range all I want is from today to 90 days from now. In the Criteria field for the 'Expiration Date' I used: >=Date() AND <=DATE()+90. Will this work? For 91-180 days I used...

That's what I was thinking. Thanks!