Query Issue

[lefty2cox]

Hi,



Using Access 2016, I had built a query called "billing". I added the following to the "clientname" criteria

Like [Enter first few letters of bill to client] & "*"

I was able to get the query to prompt for this information and then display based on the criteria. Everything was working great all day.

However, after asking it to sort on an address field while the query was open, it now prompts me twice every time I launch the query.

Prompts once, I enter a letter, prompts again asking for the same info. I'm confused now.

It still seems to work but I don't know why it's asking me twice all of the sudden. I can't imaging sorting would cause this.

Thanks
Lefty

[CJ_London]

suggest post the sql to your query

[lefty2cox]

Sorry about the run-together format. I'm new at this so I'm not sure where to break it up for ease of reading. My first time in SQL view. I highlighted in red the condition if that helps but gave all of the SQL for the query.



SELECT Orders.DeliveredDate AS Delivered, [address] & " - " & [city] AS Property, [borrowerfirst] & " " & [borrowerlast] AS Borrower, Clients.ClientName AS [Bill To], Services.Service, Orders.TotalFee AS Fee, Clients.PercentBilled AS Split, AMCs.amcServiceFee AS [AMC Fee], IIf([service]="write",[TotalFee],IIf([amcid]>1 And [billtoid]=3,([totalfee]-[amcservicefee])*[PercentBilled]+[amcservicefee],[TotalFee]*[PercentBilled])) AS Due, Orders.paiddate AS [Paid On], Orders.paid, Orders.ClientID, Status.Status
FROM Status INNER JOIN (City INNER JOIN (AMCs INNER JOIN (Clients INNER JOIN (Services INNER JOIN Orders ON Services.ServiceID = Orders.ServiceID) ON Clients.ClientID = Orders.BillToID) ON AMCs.AMDiD = Orders.AMCid) ON City.CityID = Orders.CityID) ON Status.StatusID = Orders.StatusID
WHERE (((Clients.ClientName) Like [Enter first few letters of bill to client] & "*") AND ((Orders.paid)=No) AND ((Status.Status)="delivered"))
ORDER BY Orders.DeliveredDate;


Thanks,
Lefty

[CJ_London]

Can't see anything wrong with the query - suggest check the query properties in the SQL window and remove any sort/filter properties

[lefty2cox]

Once again....perfect. Thank you so much.

Lefty