Recent content by ebs17

I think you have to approach it completely differently. What dependencies are there between specialty and specialist? Show the database schema. I would expect a many-to-many relationship between specialty and specialist, and so the form would look completely different.

Passing parameters to a query - variants: https://www.access-programmers.co.uk/forums/threads/query-to-find-records-not-between-two-dates.328481/page-2#post-1886589

Expr1="Yes" What does this have to do with positive or negative numbers?

WHERE DateField > 0 In contrast to the suggestion with NOT, index use is possible here, and index use should always be kept as open as possible in the interest of good performance. 0 corresponds to 1899-12-30 and implies that dates used are greater than this date.

In order to present something as the "best solution", requirements from a development environment such as Access should be met. A key requirement would be code-controlled access via an accessible object model or via command lines. I have enough user interface in my access frontend, as changing...

You always have to react to unknown changes, regardless of whether you use an annual copy or an entire database. Where is there a significant difference? What characterizes fields that change? Samples? These are probably bullet fields from poor data modeling. Importing new data is always an...

It is better to display VBA codes as well as SQL statements from queries as code in the forum instead of packing them in a file that is not user-friendly. The text files mentioned, which contain the definition of Access objects, play a role more for developers themselves, for example in source...

Counter question: If you could upload these formats to the forum - who could and would want to read them directly? Should one put together his own database from 10 files instead of the questioner simply providing an example with data? My first encounter with a database usually takes place by...

Save your query under a name, e.g. qryXX. You can then set up another query. SELECT DCount("*", "qryXX", "ComplaintType = '" & Q.ComplaintType & "' AND AvgOfCost > " & Str(Q.AvgOfCost)) + 1 & "." & Q.ComplaintType AS ComplaintTypeX, Q.AvgOfCost FROM qryXX AS Q

WHERE YourDateTimeField >= Date() AND YourDateTimeField < Date() + 1

The first request = determining an IBAN has been solved. Matches(0).Value returns the determined string Matches(0).FirstIndex returns its starting position (0-based) Matches(0).Length returns the string length This would allow you to cut out this match from the overall string and limit your...

The oldest trade in the world ensures that you can not only look but also touch.

PARAMETERS parMargin Double ; SELECT Q.Race, Round(AVG(Q.Rate), 10) AS AvgRate, COUNT(Q.Rate) AS Runners FROM ( SELECT T.Race, T.Margin, T.Rate FROM Table1 AS T WHERE T.Margin IN ( SELECT TOP...

? CDate("Apr-24") There are a number of formats that can be directly interpreted as a date. When it comes to names (here Apr), the existing regional settings play an important role.

? CDate(Format(202404, "@@@@-@@-24")) But the 24 is arbitrary because it cannot be derived from the year or month.