Search results

I have an accounts database that stores bank transactions in one table with a 'one to many' (transID to FKtransID) relationship to a second items table that stores the items of that transaction. The transactions table includes a yes/no field for checking off when a bank statement is received...

Hi all, Simple example of what I'm trying to achieve... Table with two fields: read_date---read_value -------------------------- 01/01/13-----10 01/02/13-----20 01/01/14-----30 01/02/14-----40 Would like to create a query or queries that summarises the data as follows: read_date--2014--2013...

Not sure if the following is possible, but below is a simplified example of what I'm trying to achieve with a parameter query. The source table for the query contains two fields: Reading_Date (short date) and Use_value (integer) The parameter query sums Use_value between two dates for various...

Can't figure out why dlookup will not work for me in a query for certain dates? Simple example to highlight the problem: Table1 - Read_Date----Read_Value 31/07/14-------10 01/08/14-------20 03/08/14-------30 20/08/14-------40 Query based on this table with the following calculated field...

Have been working on a database file using Access 2010 64bit. DB was created under Access 2007 32bit on a colleagues machine so I had to add 'Ptrsafe' labels to Functions to allow it to run on my system. After I finished modifying the database, I removed the Ptrsafe labels and emailed it back...

Hi all, I’m looking for an elegant solution to achieve the following? I maintain a club membership database, the principle tables of which are member_deatails (name + addresses etc) and club_membership (a members membership details by year). The tables are linked by a one-to-many field...

In principle should it be possible to apply a filter to a totaled query with one field set to groupby Max. I have tried this with a report, but even though the filter is passed correctly in terms of syntax (as viewed in the property sheet) it is not applied even with 'filter on' set to yes...

I'm looking for a function (I think I need to use instrRev) to break the following file path: C:\Documents and Settings\My Documents\Membership Database\MemberPhotos\Member1.bmp down to \MemberPhotos\Member1.bmp ie the file and the subfolder. Thanks Russ

Is there any way to force the switchboard to maintain its pop up window size? Whenever I open an item from it that is maximised and then return to the switchboard it too has maximised. Thanks Russell

I have a database which is used to store the records for a local flying club who's club year runs from the 5th of Decemeber - so on the 5th of December this year (2006) the club year will be 2007. Is it possible to set a value when the database is opened, say 'Club-Year', based on the above...

Can anyone please advise how I may be able to achieve the following? The database in question is used to store info about members of a radio control model flying club. I have a table (members) containing member’s personal details – names, addresses etc and a second table (club_membership)...

I wonder if anyone could advise on how I may be able to achieve the following. I have a table that contains user names plus two fields – ‘primary_channel_no’ - a whole number between 55 & 90 and ‘secondary_channel_no’ - again a whole number between 55 & 90. What I would like to be able to do...

My database has a form to input new member details. Once their details have been input I need to send them a confirmation email (message in a report attachment - Confirmation_email). Although I have achieved this manually inputting the recipient’s email address, should it be possible to pass the...

I have produced a report -Membership_Summary - from an underlying table which contains the following fields - Title (Mr, Master), Firstname, Surname and Photo (OLE object). The report works fine, but I would like to be able to not display the photos of members who's Title is set to (Master). In...

Any ideas how I could create the following report? I have a table which contains peoples names and three additional fields – Advanced Exam (Data type yes/no), Intermediate Exam (Date type yes/no) and Novice Exam (Data type yes/no). Some people will have passed all three of these exams and...

I have a table which contains invoice numbers in one field with corresponding invoice cost in a second field. The list contains duplicate values of invoice numbers, having different costs. To consolidate the data I would first like to sub total the costs of each invoice number and then...