Search results

Thank you both for taking the time & trouble to "sort" this. Brian's Iif Function is now working fine, I beleive I confused it with all the various Expressions in play, once these were deleted it works exactly as I had wanted. The Query now opens with a single Date field, correctly sorted Oldest...

Curiouser & Curioser ! I've also now entered Brians Iif Function and it works - to a point. It appears to be ignoring the "Ascending" in the Sort of the actual Expression, but it does respond to the drop down filter in the header of the Query itself, and Sorts correctly as a date - whereas the...

Hi Both, Sorry vbaInet, I misunderstood your previous post. That expression : TypeName(Nz([DateField1],[Datefield2]))returns "Date" ?

The extra ( ) is returning the same, i.e. a text string that looks like a dd/mm/yyyy Date, but is sorted by the dd ?

Sorry vbaNet, I've confused you now. What I meant to say was; I had assumed that when two fields were merged i.e. concatenated, that if one of those fields was blank, that it would simply return the value of the other Field, not return "ValueField1merged toEmptyField" i.e. the string! But that's...

Hi John, Sorry, you're post is way over my head. vbaInet, I take your point about the string, I had assumed that [Date]+Null =[Date], not "[Date]Null" I've found Nz() function and entered Nz([DateField1],[Datefield2]) as the Expression, but it is giving me exactly the same as the concatenated...

Hi, I have 2 date fields in a Table, both correctly set to Date/Time values and formatted as UK dd/mm/yyyy. These work fine in Forms & Queries. However, in one query I have concatenated the two [Datefields] in a calculated field to display as a single column. (The two date fields ae mutually...

Hi John, Thank you for your help. I got so frustrated trying to get this to work properly, I deleted the old combo and re-created it using the wizard, and it now works fine. I've been able to do away with the query in-between. The wizard actually uses the ID field as the bound field, rather than...

Dear Pat, Yes I did read your first post, but I'm guessing that the significance of what you've written has escaped me ?, and the " - a table of tables and a table of table items" has completely lost me ? Regarding your second post, I really don't expect several of these potential new tables to...

I have a tblClub with only three Columns ID,Name & Number. (Col 0,1 & 2?) I only need to store the Number (Col2) in a separate tblMembers. I've created a Combo on the tblMembers Input Form. I would like the Combo to display Name & Number (Col 1&2), but only save Col2 (Bound) to the tblMembers...

Thank you both for your input. With regard to what it is for; It originated as a simple tool to aid administration of a "team", this has now rapidly expanded to do the same for a "League" & I suspect "mission creep" will set in and financial data may well end up being included. As even 10 items...

Thank you Pat. I will try to follow your suggestion! On a general point, I had the idea that "normalisation" involved keeping all data of a similar type e.g. Addresses, within the same Address_Table. Your solution will obviously involve similar data held in PreviousAddress_Table. That will be OK...

Hi, I'm currently constructing a DB which should have <1000 records when completed. I'm aware of the Normalisation issues, but uncertain as to how far to take it ? As an example, I have 14 clubs under the one league. Should I create a separate Club_Table, or can I simply use a 2 Column Combo...

Hi, Unsure as to how to proceed with updating addresses. DB now contains some 750 records. Members addresses are stored in six separate Fields in Table, (House name, Street,District,Town,Postcode etc.)& input is by way of an Input Form. I'm not sure how to proceed if a member changes address, as...

Hi RainLover, Many Thanks for Demo, that's just what I'm looking for. I've now got a field up and running by copying what you've done.:D I presume the Module is what's doing the business ? & I presume the Table & Query are unecessary in my case (I don't want to store this Age date) There are a...

Access 2007 Windows XP Pro Regards

That would surely depend upon whether it was facing West or East ? And of course a horse could be straddling it either N/S or E/W, so presumably it's head could be a day younger than it's tail, even though the head was born first, even if it isn't born till next year ? When I get to 10 posts...

Many Thanks to you all for your input :eek: I had assumed that the expression that I had entered would give me an Age in YY/MM/DD, the fact that it was only giving me YY, I assumed was down to my lack of correct formatting - I now presume that this is not the case ? When I said that I wanted an...

I've changed the Age Control Format to General Number, and the Control now displays the correct age in Years. Can anyone tell me how to also display the Months & Days as well ? I've tried editing the "yyyy" part of the code, but this generates an error message. Thank you.

Dear Trevor Many thanks for taking the trouble to reply. I pasted the code as is into PropertySheet/Data/Control Source but got a #name? error. I've formatted the Age Control as Shortdate. Upon investigation I've deleted the Age: from the start of the code and inserted an = with no spaces (This...