Threads Replies Last Post 366 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Run Query to group Data by Week Number I'm trying to build a query off of a table that basically sumarizes by week number instead of date. so in my query I have these fields tech number - shows which tech completed the job jobs - counts 1 for every job tc_within_x - counts a 1 if there was a trouble call created on this job within 12 days TC Percentage - based on a public function that I built to calculate the TC % from TC/J... 3 30.09.2006 19:31:47 Insert only unique records to new table Hello, I have following query it just work fine and faster with say below 100 records or so. But I want the same query to run in a table where there are about 50 fields and the number of records are about 10,000. The query works but it is very slow. Can anybody please advise how to make this query run faster with some in the logic. I want to insert only unique records from customer to... 3 30.09.2006 19:23:55 Help! How do you calculate days within two date fields I am working with a Microsoft Access Database helping a non profit organization try to figure out how many nights in a month people are staying in there shelter. I have two fields a Check In Date and Check Out Date Field. Therefore to figure out the nights a person stayed, I minus the Check Out by the Check In Date. The problem is if they check in the prior month, let’s say Febru... 3 30.09.2006 19:13:50 Calculation Challenge This is a calculation challenge for a non profit to calculate how many nights during a given month did people stay in there shelter. This is the challenge. If I get the Total Nights to calculate based on [CheckOut]-[CheckIn], how can I have it only calculate the days they stayed in this case June. See Example below: In number one they have not check out yet so I need it to calculat... 3 30.09.2006 18:33:01 Need Running Balance In Form XP Pro, 2003 I am trying to develop a program for managing petty cash. I have a table with Deposit and Payment fields. I use a form based on the table to record deposits and payments. I want to create a query and calculate a running balance (sum of deposits - sum of payments), and base the form on the query so the user sees the balance of funds when making payments. I tried using ... 1 30.09.2006 18:09:01 export query to Excel Access 2003 I have a query called MyRoster. I setup a form and ask user to type in Employee Number which will be a criterial in my MyRoster query. I want user to click a command button on my form so the query result will be exported to Excel and the Excel should open and show. How to do that? Thanks. ... 6 30.09.2006 17:08:11 IIF function not working properly in my access database I am trying to find out the delay in days occurred between two date fields in an MS ACCESS 2003 Query. ScheduledDateforProductApprovalbyOBI:IIf([ActualProductSubmittalDate]<([ScheduledDateToPlaceOrder]-10),(IIf(([ScheduledDateToPlaceOrder]-([ActualProductSubmittalDate]+15))<5,[ScheduledDateToPlaceOrder]-5,[ActualProductSubmittalDate]+15),[ActualProductSubmittalDate]+7) this is the IIF f... 2 30.09.2006 16:11:50 Output Query to Excel I have aYes/No field in a table. When I output it's select query to Excel, the field is printing out as True/False. How can I make it print as "Yes" or "No" instead? TIA, Kathy ... 3 30.09.2006 15:25:01 Append query syntax requested Hi all I am a real newbie to Access (I don't even know how to insert a calculated date into a record during an action query) and John Spencer gave me a lot of help in the gettingstarted newsgroup on a similar problem. Perhaps this question should be addressed there but I feel it is getting a bit more complicated, and it is query-specific so I put it here. Apologies if in error. (Joh... 4 30.09.2006 12:12:38 IsEmpty() not giving expected results I am trying to get a count of how many columns have data entered. This is non normalized and I'm not paid to fix that :( So I am trying to get the count of shirts in this case. Alterations.Date, IIf([Shirt 1]=" ",0,1)+IIf([Shirt 2]=" ",0,1)+IIf([Shirt 3]=" ",0,1)+IIf([Shirt 4]=" ",0,1) AS ShirtTotal, IIf(IsEmpty([Shirt 1]),0,1)+IIf(isEmpty([Shirt 2]),0,1)+IIf(isEmpty([Shirt ... 10 30.09.2006 09:24:36 Union Query Report Code???? I have a small business that I run, and I have used Service Time Management wizard to build my database, with some personal changes due to the personal preference and requirements. I am right now stumped at creating a report from a query that sends out notices, ie 1st, 2nd,... for payments. The problem is that I know that there is a way to have a "template" report for all the notices, ju... 8 30.09.2006 05:45:45 Changes to Tables I have a "master" table and an "updates" table in an Access database. "Updates is imported from an excel spreadsheet with changes to some of the records in "master". Both tables have the same structure and primary key. What I want to do is match each record from "updates" with the corresponding "master" record and then create a new query showing what the differences are before manually ... 5 30.09.2006 05:10:02 How do I add string values in the same column I'm working in access and I have a table which has sequence numbers and text associated with these sequence numbers. I would like to take the text for these sequence no and combine them into one row. Example: four fields MAT 101 1 This is MAT 101 2 a basic MAT 101 3 Mathmatics course. I would like .... MAT 101 This is a basic Mathmatics sourse. R/S DEL... 6 30.09.2006 03:40:38 INCREMENTAL NBR VS. AUTONUMBER WHEN APPENDING When appending batches of records into a master table, I want ID numbers automatically created to start with the next available record number after the highest ID number in the Master Table that is receiving the appending records. I prefer an incremental numbering system rather than the Autonumber system. Is there code to create an incremental number system directly into the Master T... 3 30.09.2006 03:11:01 Question about book-catalogue I am making a catalogue for a small library. The books come in one of x bookcases. How can I indicate, in a tabel in which there is a choice between table 1, table 2, table 3 etc. that one of these must be ticked (in a "choice-round" for example) but not two of them can be ticked at the same time, if you can understand my poor English? Kind regards, Gerard... 2 30.09.2006 02:41:32 how to use SQL case statement in acess query? is access support the SQL Case statment? if not how I can get the similar function in access query? something like Select CASE column1 WHEN "abc" THEN column1 ELSE column2 END as columnNew from table1 Thanks Chris... 10 30.09.2006 02:12:22 combine two columns in one new table Hallo All, I have the following table with fields/columns and test data) called tblExport03 ID FirstName LastName BusinessEmail PrivateEmail NoMail 1 Bob Bobson bob@bobson.com bob@private.com o 2 Jim Last last@jim.com jim@mail.com x 3 Marc Johnson info@company.com info@company.com o 4 Nicole Someone @ ... 5 30.09.2006 00:59:12 Creating Query Hi: Can any one please tell me how to i write a query if TableB field MatchField contains value FieldB then FieldB join with FieldD of TableD and FieldS match with FieldSS. If MatchField contains value FieldC then FieldC join with FieldD of TableD and FieldS match with FieldSS. If MatchField contains value of FieldK then FieldK join with FieldD of TableD and FieldS match with FieldSS. If Fi... 2 29.09.2006 23:33:56 What is the statement for if something is not = "Closed","Sent","Completed"? I do not want to see these in my query when I run it. -- Thomas... 6 29.09.2006 23:29:57 Connectivity log Hi, i have a problem that i think someone will be able to help me with, i have a log file showing my router connectivity. the fields are Date, Time, cct condition the cct condition shows the result of a ping, this can either give the result UP or Down i need the time between the last down and the first up. the table looks like this: time date CCT condition 0800 280... 4 29.09.2006 22:29:07 Query for Primary key I want these all QuoteID not to appear in one of my report QuoteID is my Primary key and this my query. iif([QuoteId]<>(iif([QuoteId]>858 and [QuoteId]<910) and iif([QuoteId]>992 and [QuoteId]<1010)),[QuoteID]) Problem showing argument number is wrong. What wrong in my query, im new so i dont know much about access help will be appreciated, thanks in advance... 4 29.09.2006 22:19:56 how to use sql in ms access ... 2 29.09.2006 22:19:08 Fox Pro like running programs in Access (VB based?) Hi everyone, I have a table with a field that I need to update based on the certain conditions. For example, if Serial number are in range of 1000 to 2000 it would filled field with value "Gold", except for for specific values 1113 and 1713 I need it to be marked as "Iron" and range of 1200 to 1300 marked as "Copper". I would like to do it in the single run - rather than - in this case - ... 8 29.09.2006 21:01:29 Help With SQL Expression Hi, At the end of my SQL Query I try to put the information in policy order. I get this error message: Syntax error (missing operator) in query expression 'ORDER BY dbo_grp_project.Policy". ... 4 29.09.2006 20:49:01 how to generate a time axis with a quey Hi all, I want to make a query that will display all the minutes between two hours, i.e. The initial data are 2 different hours, let say 07:50 and 08:01 the final result should be 07:50 07:51 07:52 07:53 07:54 07:55 07:56 07:57 07:58 07:59 08:00 08:01 I want to use that as a time axis for a dynamic graph regards, Pierre... 2 29.09.2006 20:00:01 366 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>