Search results

Hi, all the formats on the form are set to currency and this is also true of the queries themselves which when run individually display the values in currency format. The relevant table fields are all formatted as currency as well. The values from qry1 and qry2 are then used in an Nz function...

I have a form to show debits, receipts and a balance for members of my club. The form is based on a query (qry3 which calculates balance from the output of qry1 and qry2) that is itself based on two queries (qry1 and qry2 which calculate the sum of debits and receipts) to produce the required...

Hi thanks for your response but in accounting terms I need the debits and receipts separate as they are different ledger accounts.

Thank you all for your replies you have pointed me in the correct direction, my failure was in not having a first and second layer in my queries, and then having the wrong join types to boot. My final query is now returning correctly using the Nz function. Thanks again.

I hope you can help. I have a small database I am using to track ledger debits and receipts for members of my angling club (110 members). Some members have bar spending some do not some have made payments for this some have not. The structure is a members details table with separate linked (by...

Now here is something weird, I closed Access and then re-opened the database and suddenly all seems well :rolleyes: I have no idea why but my problem is solved. Many thanks for your input guys. (y)

I know it should but it doesn't for some reason......

Hi, thanks but I already tried that but it only seems to work with the subform as a continuous form that then displays all the other entries which is what I am trying to avoid as I do not want her to have access to the data.

Dear All, after quite some time away from this group I find myself in a state of confusion and in need of help after resuming my use of Access........I am treasurer of my angling club and have a data base to record items members have from the bar and other items including their subscription to...

Thanks both your a quick on the draw lol

Many thanks I have no idea why I couldn't spot that! Exactly as I expected a fresh pair of eyes spotted the blindingly obvious! Many thanks Paul.

Dear All I am trying to use this code in a new database having used it in another to generate a list of records in an unbound list box (ListContacts) by typing the record number or surname in an unbound control (TextSurname): Private Sub TextSurname_AfterUpdate() If...

Well once again thanks to you all my failure to engage brain has been remedied by your help ....!You are all stars! Eric

Dear All I would appreciate any advice on the posted database example that will help me resolve my issue. Many thanks Eric

Hi have attached dummy database so you can see how the query works and the filed I wish to concatenate i.e. Description Cheers Eric

Correction sorry was having a stressful day and misinformed re procedure to description relationship which is in fact "many to one" Still not sure how to solve the problem Eric

sorry not clump but column

jdraw your thinking was correct three tables joined in query: Event - one to many with - Procedure - one to one with - Description Event is an event for a patient who can have several procedures in that event each of which maps to a description in the third table. I need to create an output...

Dear All I have three tables: Event related on to many with Procedure Procedure relates on a one to one basis with the description of the procedure in a table called ProcedureCodes. I wish to have a query which outputs three columns: Event - Prcedure1, Procedure2, etc - Description1...

Thank you all so much for your attention and help with this - as is so often the case the longer you sit staring at something the less likely you are to spot the error. Once again many thanks rest assured your help will help us, a group of busy gyn oncologists, in the UK make sure nothing slips...