Re: Rewrite a WHERE clause



Morgan:
I don't understand quite what you mean. Can you use my query above and
fit it to your example?

Thanks,
josh

.



Relevant Pages

  • One parameter for various columns of dates
    ... I set up a query that ... I can get it to work for one column of dates that fit the parameter that I ... But I cannot figure out how to have one parameter work for all of ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: difficult summing query
    ... this sort of thing is exactly what I need. ... the query you gave to fit the particular table names, etc, I now have ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • designing a report
    ... I need to create a report from a query. ... not seem to fit them in there nicely. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Update Query; But keep rest of field...
    ... Using the Design View to create a query, ... UPDATE tblItem SET tblItem.itemMfgItemNumber = "Fit ABS" ... The goal is to find all items that START with "Fitting ABS" and change them ... Fitting PVC Sch40 1" 90 ELL SxS ...
    (microsoft.public.access.queries)
  • Re: Update Query; But keep rest of field...
    ... Using the Design View to create a query, ... UPDATE tblItem SET tblItem.itemMfgItemNumber = "Fit ABS" ... Fitting PVC Sch40 1" 90 ELL SxS ...
    (microsoft.public.access.queries)