Search results

No Dick, I am located in India. Warm regards

Hi, My pleasure. Wish, I really could do more. Yes, I received a mail from info@nmeda.com & below is the content for your reference : Thank You for Voting in the National Mobility Awareness Month Local Hero Contest. You are allowed to vote once per day, so please check back regularly to keep...

Amazing. Just see if below gives some guidelines, till someone comes along : 1) Use the Minimum of DOE & Maximum of DOC in VBA to make a table, say tblReportDates with a single field TheDate. This table on generation will contain all the distinct Dates from the Minimum to Maximum possible...

Not the answer, but a few questions : 1) Is there a possibility of overlapping range ? For eg. Delhi ; 05 Mar 12 ; 15 Mar 12 ; 11 2) Is the No off Days stored in the table? 3) As an example, Why is the No off Days for Delhi...

Don't know if they accept votes from across the world, but all the same have done it. All the Best.

Is this the way your tables are structured ? tblWorkshops WorkshopID - PK WorkShopName ... tblContacts ContactID - PK ContactName ContactAddress ContactJobTitle tblWorkshopsContacts WorkshopsContactsID - PK WorkshopID - FK ContactID - FK Thanks

Sorry, Did not realise that you were new to SQL & queries, else would have explained it differently. Glad u got things working. Thanks:)

Just check out if below gives some guidelines : A make table query say : qryTop3FundersRanking SELECT tblProjects.testProj, tblProjects.Funder, tblProjects.Amount, (SELECT Count(*) FROM tblProjects AS Self WHERE Self.testProj = tblProjects.testProj AND Self.Amount >=...

It is the code for a query. Save it as a query after replacing the table name with your table name & the field name with your field name. Thanks

What criteria? There is very less information in what you have posted ( at least for me). If you post a little bit more information on the table data & what you want out of it, it would be easier for someone to help. Thanks

SELECT DISTINCT place FROM myTable ORDER BY place; Thanks:confused:

Have faced this problem a few times in the past & used to do it in somewhat below crude manner : Just check if it gives some guidelines : SELECT tablebefore.Name, tablebefore.Transit, tableafter.Transit, IIf([tablebefore.Transit]<>[tableafter.Transit],"NotOK","OK") AS CheckTransit...

check if below gives some guidelines : Let us say : TotalSum : ([Physical Support of the Child_D]+[Emotional Support of the Child_D]+[Participation and Engagement_D]+[Progress to Safe Case Closure_D]); TheAverage : iif(TotalSum=0, 0, TotalSum/4) Thanks

You will have to check that. Just take a TransactionID in the tblTransactions & then check out how many records it has in the Cards Table. Depends on what you are looking at. If you are looking at the results of the query, that has been posted, then, Yes. If you are looking at the subform...

Can you post the query that you are using. What parameter value is it asking for? If you run the query that I have posted separately initially, it should not ask for any parameter. It will display all the TransactionIDs with all the Cards associated with them. Thanks

Hi, I am confused, with the previous & this reply. Was the suggestion helpful?:confused: What I have suggested, should ideally display all the cards associated with a particular TransactionID. I assumed that is the way you want things. In case, I have it wrong, let us know. Thanks

In total agreement with all that has been said by all those that are trying to help. Now coming to what you want & perhaps get over with, just check if below gives some guidelines : tblTransactions TransactionID - PK CustomerID Buy/Sell tblInventory CardID - PK BuyingTransactionID...

Thanks Jon

Yes, Facing the same problems as OP. Very frustrating.

Just see if below gives some guidelines : SELECT Table1.PropertyName, Table1.City, Table1.Address, Table1.County, Table1.Material FROM Table1 WHERE IIf(Len(Trim(Forms!QueryForm1!PropertyName))>0,((Table1.PropertyName) Like (Forms!QueryForm1!PropertyName &...