Search results

i have a transaction form and s ubform within it. i have a field =quantity*Price this brings the total price for the item and displays it in the subform in the sunform footer i have put in =sum [totalprice] i then display this on the main form in a different text box but just get an error, is...

Query? What Query How would you perform a query to do this????

Thanks Thanks a lot will do

i have designed a form that looks up passwords in a table and enables a user to log in using the following VBA. Private Sub Combo0_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] = '" & Me![Combo0] & "'"...

I want to count the total number of records that the report contains and have tried inputting =count (*) but i just get #error is this possible or am i trying todo something that cant be done?:)

i have two seperate tables, Stock and sales. if i type the stock id number into the box in the sales form i want to bring up the name of the stock item which is stored in the stock table alongside the id number in a seperate text box in a form, i understand i need to use a query but am...

Help! Need help designing query i am currently studying a-level it and need to do a query that will enable me to input the user id into the sale screen and then this will bring up the name that is stored in a seperate field. all of my teachers are crap and i need to do this. pleae Help!