Hi group, How can I make a query that return everything that contain part of a criteiria? Example: I want to get all the names from the table employes that...

Summary Question: Is it possible to in Access SQL or SQLServer SQL to have a Compound SQL statement where one of the inner queryies is a crosstab TRANSFORM...

I have data that has _,* and spaces before the frist charater and I want to remove them. Can someone tell me how to make a query that can delete these...

Hi, I want to select records based on date which is a field that look like this: xx/xx/xxxx. I specified this as criteria in Design View: "06/15/2003" But it...

Hi, Access 2002 I have a table that has a column for a reason code (text field). Someone imported reason codes that have spaces in front and sometimes...

I have a query that prompts the user for 5 part numbers and i just use something like " or ....." to complete the query. My problem is that I want the user to...

Below is code that exists in a command button. How do I complete this code to edit the record it finds and replace the StartDate...

what is the difference between "not like" and " is not" Could anyone tell me what is wrong with this query. UPDATE table1 AS table1 SET table1.field1 =...

Can I use an If condition to define when a query applies criteria to a select in Access?

I want to select records whose dates are say 1.5 years older than today's date. How do I use DateAdd, and cand I do this in Query Design Grid? David

when a numerical query returns empty how do you make it show as 0?

Hi everybody, i have an little Problem with an expression in my query. Im using the DSum(DomSumme in german) function to sum up=20 productionquantitys per...

I have several fields that are formatted as "short time" (e.g. 10:00). I need to create a new field using an expression that would total these hours. When I...

Running the following query: SELECT M.Period, D., REG.Total_REGHrs, OVT.Total_OVTHrs FROM tblMonth AS M INNER JOIN ((tblDepartments AS D INNER...

I am assisting a client in Access XP SP2 who uses the Expression builder frequently. As of a couple of days ago, she can launch the builders, but nothing...

Hi! I have a check register query almost done. I need to prompt for the starting check number and have it place that in the first record and then add 1 to...

I'm building a Select query, for a report, from a single Table that prompts for date criteria and displays the records. I want to group and total the returned...

Hi All, I posted here yesterday regarding this problem thinking it was related to Microsoft Knowledge Base Article - 304098 ACC2000: Custom Function Called...

hi all, i've an access using union query to draw / select rows of data from 4 different excel sources using the direct file link method. i've used the...

Instead of using the Enter Parameter Value dialog box with the below criteria: Like "*" & & "*" I would like to use a text box on my...