Search results

I'm going to have to pass on this one...the code in your query is beyond my pay grade. Unfortunately, the form displayed in your screen shot doesn't reveal a problem, the record highlighted being matched successfully. As far as the relationships, I personally use matching field names in linked...

Suggestion, in case anyone else is following this thread: A table with Prabha's fieldnames and a Date field could produce two likely queries - one that determines the frequency of needing backup, and frequency of those seeking overtime.

I was drawn here also. Do you seek "who backed up whom and a count of occasions?"

I see. You want a simple query that avoids a Parameter in which you'd be obliged to type the whole plant name. A dialog form with a combo box could be used to choose the plant name from a list populated from that field.

I'm guessing that you have two linked tables, one containing as a unique value "Physical Plant Section C: Housing" for example; and the other being "all the items listed" for that division. Is that correct and if so, what are the two table and field names?

Could you perhaps post a screen shot of your Relationships page. I'm unsure how many actual Tables are involved.

Sorry, Mailman, your response interceded my slower typing.

Could you not skip the combining into string step in your form and have each choice from the List Box appear in a separate text box as "Choice1", "Choice2", etc.? Then your Criteria would be [Forms].[Form1].[Choice1] or ... etc. with an Is Not Null requirement.

It sounds as though you've gone to a lot of trouble to combine into a string a series of chosen values. Now you want to use the result in a query that has to uncombine them to replace the comma with " or " so that your Criteria row would replace S1005,S15123,S152345 with S1005 or S15123 or...

Just a comment: Should not the field name TABLE be in brackets, as it is a reserved word?

Yes, Mailman, KISS, obviously. Thx.

If using SQL, SELECT tblServices.IDNo, tblServices.OtherField, tblServices.Incentive, tblServices.Standardtypes FROM tblServices WHERE (((tblServices.Incentive)=True) AND ((tblServices.Standardtypes)="h" Or (tblServices.Standardtypes)="c" Or (tblServices.Standardtypes)="i")) OR...

First, since this is a learning experience, you should avoid spaces in your query names, field names, table names, etc. as that forces using square brackets around them in codes. SQL: SELECT ((SELECT COUNT(*) FROM [Player Scores Query Under10 Female] AS Tmp WHERE Tmp.SumOfPoints > [Player...

Forgot to mention that if two "SumOfPoints" are identical, they will share the sequential position (e.g. 2 if both second place) and next number will be 4. Likely your field name will be "SumOfPoints" instead of Points.

Let's say your query that totals points is called QryTotalPoints. It is Grouped by IDNo and has a field called Points. Create a new query with the SQL code: SELECT ((SELECT COUNT(*) FROM QryTotalPoints AS Tmp WHERE Tmp.Points > QryTotalPoints.Points) +1) AS Num, IDNo, Points FROM QryTotalPoints...

Just a question: in table B, is Federal-Aid the only field or is there also an autonumber or id field? If yes, is it a Primary Key field? Did you, for example, reach your current status by selecting the value for that field in table A from a combo box? Even parsing, with varying quantity of lead...

Since you have made the Pay_ID a Text field with Duplicates OK, I'm wondering if that was intentional. Normally it would be unique to avoid duplicate receipts. How are the Pay_ID 'numbers' assigned?

Chris, from the earlier poster's notes, I'm gathering he already has a method that produces a receipt for one item and simply wants to expand it to allow for two or more. My assumption was that a number field wouldn't accept (2058, 1234) as selection criteria, and tried to direct him towards the...

If you view your existing SQL query in Design Mode, does your parameter not treat it as 2058 and 1986 - in which case no record would match both IDs. I'm not well enough versed in code (VBA nor SQL) to write it. I use Design view and simply view the result in SQL. By placing [Enter first...

Have you tried separate parameters for each Receipt (Pay_ID) with the "OR" clause?