Recent content by cyril.casia

I have now got the brokerage calculated on the same query by adding the formula to it in the Design view. One thing which I forgot to mention, The above formula for the NetValue needs to be changed. I had mentioned it as: NetValue = (BuyPrice*5) + (SellPrice*5) Now there is a change in this...

Hai.... I got it... Its working now... How shall I go ahead with the other fields... Do I have to create a new query for every field this way?

When I open it in the SQL view, a code already exists there: SELECT tblTradingAnalysis.TransactionID, tblTradingAnalysis.ClientID, tblTradingAnalysis.TradingDate, tblTradingAnalysis.Product, tblTradingAnalysis.BUYPrice, tblTradingAnalysis.SELLPrice, tblTradingAnalysis.NETValue...

Thanks for your reply... I have made the changes in the field name... but I'm confused as to where to add the code which you gave. I have made a query for the tblTradingAnalysis. Now do I have to open the query on the SQL View and add this code there?

Forgot to mention the calculations to be done.... Here it is: NET Value = (BUY Price * 5) + (SELL Price * 5) Weight has to be automatically added as each product has particular weight. I have added a combobox for the users to select the product and added the values in the Row Source and its...

Hello All, I'm new to db and trying to make a database of the memberships in my office. Now I have a table "tblTradingAnalysis" which has fields such as........(I have attached the screenshot of the tblTradingAnalysis for better understanding) Now I have created a Form "frmTradingAnalysis"...

If so, then can I use the formula in the table to calculate the field and store it there... May be then I was retrieve all these data through a Query... i.e. User will input the ClientID, TradingDate, Product, Unit, BUYprice & SELLprice and the table will have the other fields too where the...

I treid... but this doesn't work for me.... It shows "#Name?" in the txtNETvalue. I would like this value to also get saved in the table.... Pls help....

I have got it sorted... Thank you for your help. I have another doubt... Pls help if you dont mind... As I had mentioned I have the table "tblTradingAnalysis" which has fields such as TransactionID*, ClientID, TradingDate, Product, BUYprice, SELLprice, NETValue, Weight, Unit, Gross P&L...

Please find the attachment. Have a look at it and you may then understand the need clearly. Regards Cyril ************** Sorry... had thought of uploading it here but it doesn't permit as its more than 2MB... Please share if any other option...

Thanks for your reply. I tried it, but it doesn't work for me.... Now I have a Combobox "cboClientID" in "frmTradingAnalysis" with properties as follows: Control Source: ClientID Row Source: SELECT tblmemberships.[Client ID], tblmemberships.[Membership No], tblmemberships.[Member Name] FROM...

Hi All, I'm trying to create a database for the memberships in our office. I'm new to db and thus confused at many instants. Let me explain the scenario: I have a Table "tblmemberships" which has fields such as Membership No(Primary Key), Member Name, Membership Plan, Date of Joining...

I'm extremely sorry as I'm new this forum and unaware of it... Thanks you :)

Hello Mr. Trevor G. Thanks for your quick reply. I did as u mentioned but when I open the report it doesn't show me any data... Please help.... Regards Cyril

Hello Members, My name is Cyril. I'm designing a database for the memberships in my Company. I'm very new to database/access but thought to learn and do it. I have created a table "CTAS Memberships" which has fields like *MemberID, Membership No, Member Name, Joining Date, Address, Phone...