First  |  Prev |  Next  |  Last
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Access 2K2: making numbers up in a query sum
Hi all! I am running a query in a subform where I sum a [number of units] * [operation sign]. Units are imported from a csv file with 3 decimals and operation sign is either -1 or +1: For example, [440.000*-1] + [550.070*+1]... etc... For a strange reason, Access shows 7 to 9 decimals in the sum's result. No... 28 May 2010 12:40
Joins on NULL Date values
You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or the reverse if Table2 always has a date. -- Build a little, test a little. "Andy" wrote: I am trying to avoid this solution as my tables are VERY large and it says that it is not very efficient. 27 May 2010 17:04
Retrieve all record if check box = 0 (Not checked)
Hello, I would like to see ALL (0 and -1) records if my check box in my form is not checked (0) and if checked (-1) I would like to see only record with -1 (with check mark) This is what I have, but as expected it will return only record with 0 OR -1 SELECT tblSite.Site, tblSite.Lab FROM tblSite WHERE (((... 28 May 2010 11:34
Parameter Query Using Combo Box
There are no recorsd being returned when i run my parameter query. SELECT TrackingID, DocumentNumber,DocumentType, RequestDate,DueDate, ProgramID, AssignedTo, Author, StatusDate,Subject,Notes FROM tblDocTracking WHERE (((tblDocTracking.ProgramID)=[forms]![frmProgramSelect]![ProgramID])); I have frmProgramSel... 2 Jun 2010 18:43
How to use txtboxes and Combo boxes in a form
Hello Foro Access 3003. In a form I'm trying to design a search where user only enter data in three textboxes. In a query I have the following parameter : Like [Forms].[Form].[txtName] & "*" Like [Forms]![Form].[txtCity] & "*" Like [Forms].[Form].[txtStreet] & "*" The fields: OO1, YY1, RR1 do not have pa... 28 May 2010 10:27
unique records Access 2003
SELECT valveID, Max([Date]) FROM YourTable GROUP BY valveID ORDER BY valveID; If you have a duplicate valveID/Mas of Date combos, it will return all ties. You could try changing SELECT to SELECT DISTINCT . -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Buil... 27 May 2010 17:04
Update Query not updating selected table
Thanks Daryl, I changed the SQL and it works. -- mmk "Daryl S" wrote: MKuria - Your update query is set up to update the [ChangeForm] fields. If you want to update the [AMT Per MAS] fields, then the query should look like this: UPDATE [AMT Per MAS] INNER JOIN [Change Form] ON [AMT Per ... 27 May 2010 17:04
Parameter Error for Year 2010
Not sure if anyone knows the answer to this but I welcome any suggestions for things to try. I have a crosstab query layered off of a Union query. I also have a form with a text box for the user to choose the year and a command button that pulls the report. It works fine if I choose the year 2009 or earlier ... 27 May 2010 18:11
Retrieve all record if check box = 0 (Not checked)
Try this -- SELECT tblSite.Site, tblSite.Lab FROM tblSite WHERE tblSite.Lab = IIF([Forms]![My Sites Groups]![CheckLab] = 0, Between -1 AND 0, -1); -- Build a little, test a little. "Silvio" wrote: Hi Karl thanks for the replay. The check Box located on the form is unbounded and the values will a... 27 May 2010 15:58
aggregate calculation works in select query but not an update quer
The below query works well as a Select Query. But when I turn it into an update query, I get a whole lot of nothing in the results. Interestingly, if I try to call this query from a Macro on my form, I get error (-20324) repeated the number of times that there are records in the query. It was designed to go... 27 May 2010 17:04
First  |  Prev |  Next  |  Last
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18