Search results for query: *

I have a table with many entries of dates within a particular month. I want a query that will sum all of the data for all the months. QTY_5_NEW QTY_10_NEW QTY_20_NEW DATE 0 0 0 1/1/2006 0 0 3000 1/1/2006 0 0 3000 10/1/2006 0 0 10000 12/1/2006 12000 0 0 2/2/2006 0 1000 5000 21/2/2006 0 10000 0...

yes i am saying that is an option I want to put page breaks into the Detail of the report .

How do I create MS access 2000 report with mutliple pages per record

Actually just replacing the .Text with .Value works. Thanks PHV and RoyVidar

Thank you I found out if I unmask the password in the input form It works. All i need to find out how to leave it mask and still make itwork?? NAME = txtPassword=!******! password=!123456!

did not work

Can you help me make this VBA code work with access 2000? It work with a 97 applicationbut when i convert in to 2000 it goes straignt to "Invalid Password, try again!" Private Sub cmdLogon_Click() 'check for correct UserName and password Dim SQL As String Dim recUsers As Recordset...

thanks this worked fine

Actually all the data was orginally in one table. I am doimg this because i want everyone with the same Act# to be in one record. I have to do this to the data send to another progam that needs it in that format. so I divided the records first based on another field in the original table...

I have two table with a set of records TABle A ACC# Name Name2 Name3 Name4 1 John 2 Mary 3 Richard TABLE B ACC# Name 1 Dick 1 John 2 Vincent 2 jane 3 Med 3 John 3 Mary I want to update my table A records in field Name2,Name3 etc When the act# of tables...