Recent content by 1987nac1987

I'm yet again showing my Access ignorance here but; If in the query I have a column called, say, 'TimeCode', how in that query do I get it to find the records that have that code, then only display the total of the respective 'TimeTaken' attributes? And also, where do I type your time...

Sorry if this one has been done to death, it seems so glaringly pathetic, but I've yet to find an answer that fits! I'm just putting together a query where I want to add up all the 'time' fields based on the grouping of another criteria. How do I achieve this? And also where do I type the...

I'm obviously extremely thick (which is why I joined this forum)! :D The control sources/record sources all weighed up, or at least they did to my eyes. I deleted the forms, started again and it's working now? :rolleyes:

By the way, the two forms are based upon the same table (it's near-enough a flat database) One form deals with half of the fields, the next form deals with the other half. Perhaps that might have something to do with it? Essentially I need to match the primary key on the same table for two...

Hi, I'm just wanting to create a series of buttons using the wizard on some forms I have, but for some reason clicking the radial button 'open form and find specific data to display' only returns the headings from the target form and displays nothing from the form i'm currently looking at? Why...

Thanks :) All working, all tables/queries etc prefixed.

That's fantastic! I'm already learning! Where am I going wrong with this SQL statement, then please? SELECT [NC Log].DateOpened, [DueDate] AS Expr1 FROM [NC Log] WHERE (("DueDate:"=DateAdd("d",30,[DateOpened])));

Hi there I'm very new to access and this is (hopefully) a simple question, maybe someone can help me out? I would like to create a calculated field in a table that takes a date from that record and adds 30 days to it and stores that value. How do I do that, then?! :D