RE: using a calculation in a query

Tech-Archive recommends: Fix windows errors by optimizing your registry

The SQL you posted earlier did not have any criteria. Post the one with the
calculation in the criteria.

"Shel" wrote:

Will you please walk me through this? I am really green as an Access user.

"KARL DEWEY" wrote:

Post your SQL the includes the calculation in the criteria field.

"Shel" wrote:

I am writing a query from a table. This table pulls from a form that has an
age calculation in one field. This result does not store in the table, and I
have been told I need to create a new field in the query and insert this
calculation. When I put the calculation in the criteria field, it makes all
records vanish from the query. What am I doing wrong? In case it's helpful,
I'm including the sql view below:

SELECT Demographics.VRS, Demographics.SSN, Demographics.[Last Name],
Demographics.[First Name], Demographics.Phone, Demographics.Age,
Demographics.[Service Connection], Referral.[Scheduling Deadline],
Referral.[Consult Deadline], IT.[IT End Deadline], SE.[SE End Deadline],
TWE.[TWE End Deadline]
FROM (((Demographics INNER JOIN IT ON Demographics.SSN = IT.SSN) INNER JOIN
Referral ON Demographics.SSN = Referral.SSN) INNER JOIN SE ON
Demographics.SSN = SE.SSN) INNER JOIN TWE ON Demographics.SSN = TWE.SSN;

.

Relevant Pages

  • RE: using a calculation in a query
    ... Having the form open when running the query stops the criteria ... FROM (((Demographics INNER JOIN IT ON Demographics.SSN = IT.SSN) INNER JOIN ... In the criteria put the below formula. ... results of the calculation is only the month/day and the table has ...
    (microsoft.public.access.queries)
  • RE: using a calculation in a query
    ... If you run this query with the form close and enter a number when it prompts ... "Shel" wrote: ... FROM (((Demographics INNER JOIN IT ON Demographics.SSN = IT.SSN) INNER JOIN ... results of the calculation is only the month/day and the table has ...
    (microsoft.public.access.queries)
  • Re: Update Query Error "Key Violations"
    ... UPDATE Workshop_Registrations INNER JOIN Workshop_Credits ON ... Storing derived data such as this in your table accomplishes three things: it wastes disk space; it wastes time (almost any calculation will be MUCH faster than a disk fetch); and most importantly, ...
    (microsoft.public.access.queries)
  • Re: Query Criteria
    ... and the criteria on this field to ... When I run the query Iam asked for the parameter values for & ... >and then compare that to StockReorderLevel. ... > sure you don't return a null value for either calculation. ...
    (microsoft.public.access.gettingstarted)
  • Re: Due date query
    ... against the calculation, you will get one of the two error messages you have ... And then your criteria should be ... Now, I want to limit these results to any maintenance due prior to today, ...
    (microsoft.public.access.queries)