Queries

Percentage change
I'm sure this gets asked over and over again (I did try to find an answer). I have a table that has four fields, three of which are, when combined, unique. The fourth field is an index. I want to be able to get the user to specify how many months (one of the fields) back they want to make the comparison and th... 13 Sep 2006 16:31

DateDiff Time
Hello, I'm trying to get a DateDiff expression in a query to result the subtraction of time2 and time1, but when in the query the result doesn't showup until its clicked and is negative. Here is the expression DateDiff ("n", [time1], [time2]) . I'm a newb at access so any info would greatly appreciated. ... 11 Sep 2006 22:26

Undefined Function '[Format$]' in expression
Hi, We had been sent an access program that had been used by them with access 2000. We use Access 2003 and a couple of the queries are generating the undefined function error. I checked the reference Libraries and there aren't any there with missing in the name. These are the libraries that are currently sel... 8 Sep 2006 09:54

Month Text Problem
Hi Groupies: I have a parameter query that retrieves appointments based on the school year of September to June. The problem is that we need to be able to retrieve data for an entire month at a time, not specific dates. For ease of entry, we would like to enter a start month of September and an end month of... 5 Sep 2006 15:17

Auto Fill prompt
I have a query which deletes based on a Bill of Ladding number which the user is prompted for. The SQL Statement for this query looks like this: DELETE [204HEADER].BILLOFLADDING, [204HEADER].* FROM 204HEADER WHERE ((([204HEADER].BILLOFLADDING)=[BILL OF LADDING])); I then created a form which has a command bu... 5 Sep 2006 14:13

Calculating Dates
Hi, I am using Access 2003. I have a table that includes completion dates and times (separate fields) for steps in a job. Here is an example of a table (please excuse if there is a line wrap): JobID Area CurrLine Cmplt_DT Cmplt_TM PrevLine NextLine 1 ABC 1 8/1/2006 08:42 ... 25 Aug 2006 09:33

Query Access 2007 "Disbled Mode"
I setup a new Access Database in 2007 but saved it as 2003. I linked ODBC three tables to a SQL Server. I then wrote a Make Table Query that had a criteria for a certain type of record. When I run the Make Table Query it says in the lower left corner the following error: "The action or event has been blocke... 22 Aug 2006 19:30

Query Access 2007 "Disbled Mode"
I setup a new Access Database in 2007 but saved it as 2003. I linked ODBC three tables to a SQL Server. I then wrote a Make Table Query that had a criteria for a certain type of record. When I run the Make Table Query it says in the lower left corner the following error: "The action or event has been blocke... 22 Aug 2006 18:26

Percentage question
evidently i'm missing something. i the code mentioned here. i have a txt field [%Complete] i call the field in my form: After Update =MakePercent([%Complete]) when i enter 25, it converts to 0.25 i want to enter 25, and it convert to 25% how do i do this? "Allen Browne" wrote: Save this fu... 17 Aug 2006 12:46

make table query SQL
I'm reviewing a db sent to me by a colleague. It appears to have a make table query in it, with the following SQL: SELECT tblELR.ID, tblELR.[Effective Date], "N/A" AS [Asset Number], tblELR.Description, tblELR.Vendor, "N/A" AS [Manufacturer Name], [Amount DR]-[Account CR] AS Cost, Null AS CurrentUnits, Null A... 15 Aug 2006 12:02