microsoft.public.access.queries | Forum profile

  On Wed, 7 Jan 2009 22:22:01 -0800, Milan Wendl, aaaengineering.com <MilanWendlaaaengineeringcom@discussions.microsoft.com> wrote: >Hi, > >I have 2 tables with same structure but varying records related/linked by ID >field in both tables offcourse. >I would like to update all fields at one shot with Update query at once >without listing all these fields with Set statement. You...

  Four possible solutions at http://www.mvps.org/access/queries/qry0020.htm Vanderghast, Access MVP "cixelsyd" <u48663@uwe> wrote in message news:8fd8311c4b721@uwe... >I have a table containing transaction data for many > items (Partno). Each item may have several entries in the table due to > transactions on different dates (TDate). > I wish to select the complete record...

  Often, a combobox will store the "lookedup value's" recordID, even though the lookedup value is what is showing in the form. But you said you are using "tblItem.ProjectStatus" -- the implication is that you are using a TABLE-based lookup field, rather than a combobox on a form. In that case, you have discovered one of the reasons why folks in these newsgroups recommend AGAINST using the...

  BTW, You might want to consider using an alias when posting to newsgroups. There are web bots that scour these newsgroups for valid email addresses. -- Dale email address is invalid Please reply to newsgroup only. "ezgoer89@gmail.com" wrote: > I've searched and searched and cannot find a solution to my > challenge. I have created reports in Access using SQL and currently > have the...

  http://s106.photobucket.com/albums/m268/KenNiuM/?action=view&current=Untitled.jpg This is my SQL for the query above which is query 1. SELECT CashierLoginDetails.lStaffID, Max(CashierLoginDetails.[lDate/TIme]) AS lDate_TImeOfMax, Last(CashierLoginDetails.lCashRegister) AS lCashRegisterOfLast, SalesTransaction.stPaymentMode FROM SalesTransaction INNER JOIN CashierLoginDetails ON (SalesTransaction.stCashRegister =...

  Something like the following might work INSERT INTO TRAININGCompleted (TrainingID, EmployeeID) SELECT TrainingNeeded.TrainingID, Employees.EmployeeID FROM Employees, TrainingNeeded WHERE TrainingNeeded.TrainingID = 26 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Shane Morrison wrote: > I have three tables, one that list employees (153 entries), one that lists...

  Hi all, I've got a what I'm sure is an easy question for the pros. Please se below for details as it is a follow-up from a previous problem. ----------------------------------------------------------------------------------------------- Michael, thanx for the tip it works like a charm. I now however want the query to run even if i dont select any of the criteria from the multi-select box. I know I should have "...

  Thanks for your reply. Do you know where I can find an example? I tried but with no success... - Show quoted text -  

  Your answer says my simple response obviously doesn't cover the situation. hmm Someone with more specific knowledge about the situation will have to chime in now. Ron  

  Your posting is a bit scattered. The "First" of Value can contain several field concatenated together. You can also use IIf() and other types of expressions. -- Duane Hookom Microsoft Access MVP "EAB1977" wrote: > Is it possible to combine two columns in one in a crosstab query? For > example: > > TRANSFORM First(qryVDRProductionRuns.TestValue) AS FirstOfTestValue...