Search results

Sounds like your table structure is incorrect. You are probably trying to use a One to Many relationship when you obviously have a Many to Many relationship between software programs and computers. You need to use a third table, call it ComputerSoftware join. In this table you will include...

Outlaws shouldn't cry :D

Keep in mind, you are comparing string VALUES, not string CONDITIONS. This is key when you are trying to do query strings in condition boxes. Instead of Choose, use the single-value Iif function return function. My table is called tblProcessType, and the field is called ProcessTypeName...

I'm slightly unclear on some conditions. Example (f2 omitted for clarity): f1 f3 1 AA 1 BB ... would mean that you need a field that assigns "-" to 1. However, f1 f3 1 AA 1 BB 1 BB You see that f1, with a value of 1, although f3 is not all the same for 1, there are...

Create a subquery that contains just the customer ID in the SELECT line, with the WHERE clause the transaction date, limiting the field to only transaction dates from 1-1-2005 and later (probably from the Orders or the Transactions table). Once the subquery is finished, copy the SQL. Open your...

Actually, this operation can be done in one line as follows: Right(Left("NE1220904", 5),3) If the length of the string does NOT change from field to field, using the Mid function is easier, as follows: Mid("NE1220904", 3, 4) In this scenario, the Mid function uses three arguments. The...

OOPS, I meant Jet, not SQL... sorry.

SELECT Count(tblTable.FieldName) AS CountOfFieldName FROM tblTable WHERE (((tblTable.FieldName)="processed")); ...will return the number 0 if "processed" is not in the field NOW... look up Like and the wildcard operator in Access help if you are looking for any occurence of "processed", not...

Actually, the problem is more complicated than that. In many cases, an email address may be part of a string or html field that don't have spaces in front of and behind the email address string. It is quite common for email addresses to be in html format, such as <myname@mymailaddress.com>, or...

Having separate fields for Date and Time is a bad idea. Keep in mind the Date datatype is actually a Double number, specifically formatted for Date and Time functions. The number represents the number of days since Saturday, December 30, 1899, while the fraction part of the number represents...

I agree. In fact, I would recommend not using First or Last if possible and using SQL aggregate functions to obtain the desired record.

Let me see if I have this straight. 1. You have a form with two dates 2. The first date is the start date for the query. 3. The second date is the end date for the query, 4. You want to create the query to return records from, and including, the first date, up to, and including, the second...

Although I think your question is probably more complicated that you wrote about, from the information you gave me you wanted the record with the MAXIMUM Hole Number value. The query is easy, if you are just looking for the top record. Substitute table and field names as appropriate. SELECT...

Sorry for the late reply. For some reason my forum "reply" indicator wasn't working. Join tables are different in their Primary Key setups. For records to be unique, the combination of the foreign keys comprise the unique record indicator for that table. In this case, the AuthorID and the...

Create a field called "PDate" (for "Previous"), and assign it to the the value [SDate]-7

I am confused by your request. What do you mean by 'capturing' the dates? I though Sdate WAS the date you were capturing.

Here's some code you may look at. It also includes creating a chart in Powerpoint.

Try removing the "ALL" from the Union statement in pbaldy's answer. In addition, the fields you are trying to match in all queries MUST be the same datatype; that is, the first field listed in each query must identical datatypes, the second field in each query must have identical datatypes...

Establish the same type of relationship between tblArea and tblComponent, as you do with tblArea and tblMajorItems. So far, so good. Now you need to associate tblComponent with tbleMajorItems, WITHOUT reference to tblArea. That means you need to establish a many to many relationship btween...

Check out the AfterUpdate event of the combobox in Access Help.