Search results for query: *

Oh man, what a dumb mistake. Thanks so much for your help. I really appreciated. Some times you just need someone else to take a look with fresh eyes. Thanks again.:-)

Hello, I have a problem with a SQL script I am using in Visual Basic. Here is the script: SQLStr = "SELECT Count([user_stamp]) as Fleming FROM dbotest3 WHERE (((dbotest3.user_stamp)='WEBNAME') AND ((dbotest3.date_stamp) Between #06/1/03# AND #06/30/03# ))" This gives me a return...

Actually 'WEBNAME' is an entry in the table named dbotest3. That's why I have : FROM dbotest3 WHERE ((dbotest.user_stamp) = 'WEBNAME')) user_stamp is a column name in the dbotest3 table. WEBNAME is actually a name that the customer enters on another form not related to mine. Does this...

Thanks a lot for your help. I am very close. I can feel it but I am still not getting the correct output. I entered these parameters: SQLStr = "SELECT Count([user_stamp]) as Fleming " & _ "from dbotest3 WHERE (((dbotest3.user_stamp)='WEBNAME'))" & _ " AND...

Well, here is the full scenario. I need to create a vb application that will go an Access database and extract data from a table. This table captures payments made by the customer. I need to capture how many payments were made by a particular customer during a period of time. I created a SQL...

Thanks for your help. This is the first time I have done this here. I am trying to obtain a list of dates between the two dates specified. Once this information is obtained I want to compare it against a table in Access Database which contains customer information. If there is any activity...

Hello, Can anyone please help with my situation? Here is the scenario: I am trying to retrieve the dates from two dates I have in two separate text boxes. For example: Textbox1 = Date 1 ( example 6/01/2003) Textbox2 = Date 2 ( example 6/05/2003) I need a way to code this in Visual Basic to...