HI, I have a query that finds duplicates based on and which works fine however what we have discovered is that if the name has a variation i.e. Rob...

Hi, Hoping someone can help. I've got one table with a list of transactions, each transaction has a user code assigned to it (i.e. AA, aa, Ab, BA, etc.) I...

Our Project Manager hates SELECT *, he wants us to list all columns in our SQL. Does this make a big difference in Access? The PM is mainly a SQL Server...

Can anyone suggest a work around on this problem. It seems that formula for date difference, weekdays does not work in Access 2003. The formula to calculate...

When I divide two numbers in a query the result is displayed left aligned. How do I get it to be right aligned?

Hi. I have a problem here that I can't figured out a solution. I have a query this this fields and values: ProdctionNo Production Value1 ...

Is there any way in Access (2003) to edit a query's SQL statement without first going into design view? Some linked tables on our main database have inherited...

Can someone help me out with how to enter the correct expression in a field of a query? I want the calculated field to return "N/A" if the result of a...

It is possible to run a query to inser a blan row in my table? If yes, can you please let me know how can I riight SQL? Your help is great appreciated,

Ineed to create a Make Table quey that will apply an auto numbertha resets with a change of value in a speciffic field. The end result would be to create a...

I would like my parameter query to bring back records by the end user typing the first three letters of a description. There should also be the option of...

The toolbar and cursor keep flashing non stop in WORD and other applications (not the internet). I have had DELL technicians look at it and no-one can sort...

Is it possible to use parameters in the select line e.g. PARAMETERS Param1 Text ( 255 ); SELECT AS Expr1 FROM Customers WHERE = 'John Smith'; For Param1 I...

I have a query that has a syntax error. The pop-up error window takes focus and one cannot use the design view window to make the needed correction. If one...

Is it possible to create an expression based on a parameter query?

I have eight text boxes from which I filter data on records on a form. I want to make a table using a Make Table Query with the Name of the Table being the...

I have a table with one address field of street address, city, state and zip and need to split them into 4 fields. Is there sql I can use in an update query...

I have a recurring problem. Table A has these fields in each record: Account - Month/Year - Edition - Amount For any account there are records for each month...

I have the following VBA code that is supposed to insert values into a table based on a select statement and a variable. lngID is a variable that is being...

I have a query that needs to display only the records that the field is blank or "Project Manager" I get only project manager or nothing at all. Please...