Recent content by B4Geyer

See if the KB article KB88670 helps at all: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B88670

A sample db posted today used a qry expression that calculated tax based on 2 different rates pre- and post-July 1/06. http://www.access-programmers.co.uk/forums/showthread.php?t=110308 I'm wondering how to do a similar thing on my Staff qry. Crosstab qry has salary calculations, expense claim...

Sounds like you're also asking where the SELECT statement would go...:cool: ? Click on SQL view in your query (same button that lets you switch between Design and Datasheet view) and replace it with the one you got here. HTH

Thanks for the sample, John. I'm actually trying to figure out how to do what you referenced above in order to make a concatenated field that combines the same field from different records, but I think i gave a rather clumsy example of how it would be used. I have several form letters...

I had a similar thing in a large report. In ours it was a case of not allowing duplicates, but for some reason the report still made room for them as if they were there (lots of weird blank lines). You can set the properties of the group headers/footers/detail sections to Can Grow:No, but that...

Not sure whether this is any help, but if you do a quick check in Northwind of the "Employee Sales by Country" there are sub-group and group totals in each group footer, with different types of calculations. I don't think any of these have a Count function, but if you put the Count in your...

Concatenating same field from multiple records ANSentry: Your sample db showing the different methods is very helpful. (1) When navigating through each records in your frmCusGeneric the 1st 2 concatenated textboxes appear quite a bit later than the bottom couple done with code. Would this...

Date & time We are using the automatic time stamp - that's the problem we want to bypass. ghudson, thanks for pointing some specific places to start - although I have spent much time searching I hadn't found too many date/time options that our system would download. MVP John Viesca's date time...

Hi, hope someone has an idea of where to start on this. Our company offers projects to multiple contractors and we have to enter when we spoke to them and their response. I put a textbox with default of Now(), thinking these would be recorded in real time and it would be no effort at all. But...

YesNoCombo.zip Check out ansentry's YesNoCombo (attached) - it work really great The man s a genius:D

John, you just saved my bacon there - hadnt thought about price changes wrecking historical invoice infrmatoin. Thanks