Recent content by Bullschmidt

You originally wrote in part: And later after Update Query recommendations you wrote: So instead of using a form in the usual Form View I would suggest using the form in Datasheet View (showing multiple records at one time) or a query (showing multiple records at one time)...

I just did a test using 6 textboxes and this apparently worked... =DateDiff("d",Nz([txtExit1]),Nz([txtEntry1]))+DateDiff("d",Nz([txtExit2]),Nz([txtEntry2]))+DateDiff("d",Nz([txtExit3]),Nz([txtEntry3])) So in the Exit and Entry textboxes with dates like this: 3/16/2020 3/18/2020 Blank Blank...

And with the Append query the field names don't need to be the same in both tables as they can be individually specified...

Seems like a lot of good responses above. And now you wrote: And you originally wrote in part: Well I guess you could still use your DoCmd.TransferSpreadsheet to import data into a table but just make it a new table with all the correct field names. Then create an append query to take what...

Yes isn't it interesting that DSum() and DMax() need the Nz() (to convert a Null to 0) but DCount() does not...

Maybe you don't even have to deal with the year except for the first entry of each year which you could manually correct. For example data in a ProjectNumber number field could be something like this: 20001 20002 20003 20004 And then to calculate the next ProjectNumber you could find the...

Not sure what expressions you were dealing with (maybe something really complicated, or maybe just the fact that in a totals query things are always sorted by the grouped columns first) but just tested and this PercentageCorrectCalcAndTraineeID calculated field was able to be sorted in the queries.

After thinking some more about the sorting in case of ties issue here is a workaround: In qryTestResults1 change this: PercentageCorrectCalcAndTraineeID: Str(Round(Sum([Correct])/Sum([Questions]),4)) & " - " & [TraineeID] To be more like this instead (putting "1-" i.e. one minus in there)...

It looks like West.Eff and West.Exp column data is switched. This assumes that West.Exp is supposed to be the newer date like East.Exp is to East.Eff.

Well I suppose in general if you had to revise your approach to something that actually works (updateable) you could in code loop through all the records of the totals query and for each row run an update query for just that one record...

The way I sometimes deal with that is having the criteria in subqueries and then the main left join in the main query.

Nice handy example as it sure seems odd that can't just do it from a linked table...

Yes and by the way who really keeps their comboboxes named something like "Combo20" anyways, right :)

o Changed the name of the query from qryTestResults to be qryTestResults2. o Created a new totals query called qryTestResults1 with the following: - TraineeID field as follows: - Total set to be Group By - PercentageCorrectCalcAndTraineeID field as follows: - Total set to be Expression...

Well if you're just talking about straight text you could put that on your main report just above (but in the same section as) the subreport(s)...