Search results

SELECT Table1.T1Field1, Table1.T1Field2, Table1.T1Field3 FROM Table1, Table2 WHERE (((Table1.T1Field1)=[Table2].[T2Field1]) AND ((Table1.T1Field2)=[Table2].[T2Field2]) AND ((Table1.T1Field3)=[Table2].[T2Field3])); Notice there are no joins in the FROM clause.

OK, see the picture. Cross tab won't work in this case. Unless somebody pops an answer to you, I can take a gander at it a little later today, perhaps 6 hours.

Can you show what your result should look like? You are trying to do a non-aggregate query that cannot display different name values in columns, so a crosstab won't work. However, I don't know what you are trying to show, so just show what you want the RESULT to look like, and the gurus here...

Sorry, mate, I'm in California and was working, it's 9:30 am here and you are probably already pinted out. :p Here's yer consolation. Hope you get better. SELECT tbl_Sales.customer_name, tbl_Sales.invoice_date FROM tbl_Sales WHERE ((((SELECT Count(*) FROM tbl_Sales AS tbl_Sales_1 WHERE...

I think this happens when you have several books assigned to one author. I assume you have authors and books assigned in a many to many relationship with each other, creating a third table that organizes the joins. I wonder if using SELECT DISTINCT would work for you. On the other hand, you...

Did you check EVERYWHERE? I mean, if your macros are pulling recordsets, that means the query names have to be changed as well! Another thing you may check is to (temporarily) convert the macro to VBA, then looking at the vBA code to see if you left anything out. Unless RDI is a global...

Is it possible that you are trying to get an array of values, rather than a single value? The problem probably lies with Excel, not Access (unless you can program the request correctly through VBA). Without knowing exactly what you are trying to import (do the sheets contain arrays, for...

Try looking at Pat Hartman's db, it's pretty comprehensive. http://www.access-programmers.co.uk/forums/showpost.php?p=260505&postcount=1

As an aside... GoogleEarth, the satellite mapping application, has a feature that shows the GPS location in the status bar of the current mouseover position on the map. If you want to get GPS coordinates of ANY place in the metropolitan areas of the US or Europe, just look it up on the map...

Assuming that your time code is stored in tblTable.TimeString in this STRICT format: HH:NN:SS:FF Where: HH = Hours digits NN = Minutes digits SS = Seconds digits FF = Frames digits EVERY element must be two characters long, so make sure you include leading zeroes for hours! Queryfield...

In general, when you are hard-coding dates, use month names in the date field like "January" or "Jan". For instance, #1 Jan 2004# works just as well as #Jan 1 2004#. That way you will completely eliminate any date hangups.

Check the Nz function for the field that supplies the top row.

My bad on the formula. In the FALSE condition of the Iif statement for the %Cur field, which is the last number in the statement, replace 0 with 1 (which will format to %100, instead of 0%). To calculate the Compensation Year as Next year, use the following: QUICK EDIT: Actually...

Let me see what you want in the query. For compensation discussions for Year 2006 you need: % Year 2004 Employed % Year 2005 Employed For compensation discussions for Year 2007 you need % Year 2005 Employed % Year 2006 Employed Therefore, you have two query fields you need to populate...

You show your Date and Time as different fields. In the database, they should be stored as one field. Keep in mind you can format the display of the date-time field in any manner you choose. IN addition, the ID field would normally be used to find latest entries. However, I"m not sure if you...

Assuming your field in the query is called "StartDate", this query will return the percentage of the year worked for that particular date. The key to calculating the percentage is the DatePart function. Setting the date interval unit to "Y" returns the day of YEAR. For instance, if the...

Be careful on the SetWarnings command. It is good practice to included the "SetWarnings True" statement following the processing of the action. Although the command is not SUPPOSED to affect the current application's settings, it has happened in the past for me. Better safe than sorry.

Have you tried the resolutions stated in the Microsoft paper? This definitely sounds like User Permission problems on the server side DB. Here are the four major problems and potential solutions for your problem: 1. The most common reason is that the Internet Guest account (IUSR_MACHINE)...

Glad you got your problem fixed. I apologize if I didnt make myself clearer earlier. Sometimes I have to read two or three times to get things right. I see that in your original post you did indeed leave out "Balance", therefore there is no need of an update query. I still fail to see...

Assuming table name tblTable, name field FullName, and new field called Status, UPDATE [tblTable] SET [tblTable].FullName= (Trim(Left([tblTable].[FullName],InStr([tblTable].[FullName],"(")-1))), [tblTable].Status = IIf(InStr([tblTable].[FullName],"(NS")>0,1,0);