Search results

I have, what I think, is a basic union query: SELECT [Breakdown Union xFY].ENDUSER_CUST_NUM, Sum([Breakdown Union xFY].[FY 2009 Covered]) AS [Product Value Sum], "FY09" AS [FY Covered] FROM [Breakdown Union xFY] GROUP BY [Breakdown Union xFY].ENDUSER_CUST_NUM, "FY09" UNION SELECT [Breakdown...

I recently found this sample code on how to concatenate data fields: Public Function concat_alrgy(Patient_ID) Dim rst As DAO.Recordset Dim db As DAO.Database Dim hold_alrgy As String Set db = CurrentDb hold_alrgy = "" ' clear out old list DoCmd.RunSQL ("delete * from t_patient_alrgy") '...

I have a decent sized Excel 2007 sheet which contains contract information. One of the fields is the date the customer renewed their contract. If they haven't renewed yet, then the field is blank. When I try to import this sheet into Access 2007 it gives a conversion error on the rows which...

I am having a problem formatting some numbers in a UNION query. I have two simple queries which return basic scores and their average for a specific period. I have each query rounds the averages so I don't get any decimals (EX 9.3333=9). When I use a UNION query to get the two separate...

I am having trouble adding different values in the same text field together. Think of it like doing a SUM on a field in a table. However, with XT it obviously doesn't work. I read how to do this if they were in different fields, but can't figure out how to do this if the values are in the...

I am having a similar issue as the user here: http://www.access-programmers.co.uk/forums/showthread.php?t=185520 I have a query which is a basic select query on a few different linked tables. It saves quite quickly. However, when I add a crosstab query in the mix it takes a couple of minutes...

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...

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...

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...

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...

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...

I am stuck on this one, any help would really be appreciated. I have 5 simple queries which all draw upon the same customer data. They just cut the data into different groups based on various criteria. All of the queries output the same fields including the name of the group they're in. Now...

I'm trying to create a macro which executes different saved imports. I've read on a few different forums, along with this one, about either the 'runsavedimport' action as well as the 'texttransfer' action. I can't find either of these in the action drop-down when you create the macro. One...

I'm really stuck on this one and need your expertise. I have a simple query which checks to see if someone is current on their maintenance for the year. The problem is sometimes they purchase more than one item and don't always purchase maintenance for the other items. Maintenance...

I've searched this forum and others and haven't found an answer. Please forgive me if I missed a post. Every quarter I have to import about 30 large files into my database. I've been renaming the files to a standard, running a saved import, and then repeating. This is a complete pain...

Question using IIF... I have an IIF statement which looks at the ending date of a customer's maintenance to see if they are 'current' or not. Maintenance Status: IIf([Invoice Data]![Maint End:]<Date() Or [Invoice Data]![Maint End:] Is Null,"Expired","Current")For the most part, it works...

I have a simple table with about 20 or so fields and about 390K records. This same structure is in three local databases (one for each business unit). One of the fields was incorrectly imported as text instead of date. I would go back and re-import the data but that is a complete pain. It...

I'm not even sure what to call this thread let alone how to search for it in the forum. Query Array is as close as I could get :confused: I need to find out what customers exist in each of 6 groups as well as the combination of those groups. I know the customers in groupA, groupB, groupC, etc...

I'm trying to save some time and effort by combining some frequent queries into one. Basically, I need to see the customers which have purchased in FYxx and have not purchased in FYxx+1 AND FYxx+2. To do this I need to create 4 queries: [FY06 TCC] gives me the customers from FYxx SELECT [Main...

Some of my queries return results with tens of thousands of records.....sometimes hundreds. I think the query was built correctly. The query makes logical sense to me, but keep in mind how inexperienced I am with Access. What is the best way to validate the results of a query? How do you...