Being new to access and limited experience with SQL , I'm finding that the execution of queries can be tricky. I'm looking for guidance on how to best...

Hello All: We are trying to update about 8,000 customer records and unfortunately inherited some fields that heretofore had very few input parameters. We...

I'm trying to set up a cross tab to report "valid", "invalid" and "total" transactions (rows) by month (columns). I have a form on which a user can select a...

I have one table that contains Today's Date. I have a second table that contains fiscal month dates. For example July = 6/28/2008 - 8/01/2008. I need to...

I have data by log date and I want my query to group calls by week Mon thru Sun. I also want to do by month. Is there a way to set that up? thanks Log...

I am trying to perform an update query using 2 tables. The first table is a billing file with many records per employee id and there is also an employee...

Hello everybody, I have two related tables: 1) Tbl_categories with fields category(Text), id (Counter and primary key), UserID (long) 2) Problems with fields ...

Hello, I have a checkbox in this Field "Red Line" and i have this calculations in my query that counts number of True Red Line:...

The below query works as expected until I add the LEFT function to get the left 16 characters. I keep getting the entire string. Menu:...

I am getting the following suntax error: "Syntax error in string in query expression '=6'""(second quote is not in the error screen). Here is my DSum...

I'm getting a Syntax Error on this. Any Suggestions? Thanks DS Dim OUTSQL As String DoCmd.SetWarnings False OUTSQL = "UPDATE tblTimeLog SET...

I have a table that holds a field called "Expiration Date." On the query, how can I get a pop up that prompts the user to enter the number of days left...

LS, I have to tables, say A and B. For all records in A I would like to find a corresponding record in B. Unfortunately I can not do this using a unique...

Hi! This is balakrishna i got a issue that in a table i have two fields those datatypes are "TEXT" and "OLE Object" how to write a query to convert text...

I have looked at every suggested reference on this site and I still cannot seem to wrap my head around this. I have the...

I am trying to use the Instr statement with no success for my VendorCtry field. The following is what i have in the query field for InStr(,). Is this not used...

I have a bunch of union queries in my Access database in which I've written the following type of SQL code: SELECT FROM WHERE =True UNION SELECT FROM...

What is the sysntax to refer to a subform in the conditions statement of a query I tried the following !!.! but that doesn't work thanks

I am trying to update the field which is in the table with strInputtext (this variable is a string) When it runs it does not seem to do anything at...

Dear Duane, As you know I am using your function. aaa: Concatenate("SELECT Time_ranteboy & ' (' & aitia_pros & ')' FROM RT_AM_ranteboy WHERE date_ranteboy =#"...