I'm trying to migrate the following queries to T-SQL for SQL Server 2005, but getting errors. SELECT tblCurrent.AutoNumber, tblCurrent.TaxYear,...

Hi all, I'm trying to create a transform query with VB6, ADO 2.8 and Access 2003. I'm basically doing the following: 'Create catalog connection Set...

Perhaps someone has seen this - I have a client who uses MS Access to keep track of vendors and booths for trade shows. What happens is that the data in the...

been trying to work out how to do this I've worked out the part query, but trying to work out the null section, this query is running from a form, with a...

I'm hoping someone can help me with this. I have a table that holds basic contact information as well as what part of our organization the person is a part...

Hi I have created a query from form, I am able to use the * wildcard if I wish so all is well so far. What I would like to do is have the * as the default...

Kindly advise me how to SELECT fields values from a table as cocatenated string?

Hi, We receive an excel workbook of information from an outside source. Within this table the customer may have several record lines assigned to their...

You sent me this code: Public Function GetLetters(strBookCode As String) As String Dim lngCtr As Long Const conAlphabet As String =...

I need a formula to put in a query showing the difference between two columns. I have a current amount column and a previous amount column. I need to show if...

Hi I have a Query which contains a field I want the user to be able to specify an as of date and I want that as of date to include the date that they...

Is it possible in Design View to list more than 9 OR criteria without using SQL? I have 12 fields and need to apply a criteria to each one to see if a...

Hi all, I am a little stuck. I basically want to see the first date when any person has more than 60minutes free. import_date = the date the data was...

Hello, I need to load the last N records from a table. The last N records are determined by date. And I want N to be a parameter in the Query. How can I do...

Any help on this small problem would be greatly appreciated. I have numerous pivotcharts set up from a query, but would like to make it so that i can move on...

Hello, I have a query that is pulling the sum of a field in a table based on criteria. Then there is an expression field in the query that is multiplying...

I experience very strange problem in Access 2003. If I try to run quite a simple query from CurrentDb.Execute command it will crash my database. From another...

I found this query that claims it can display the maximum (latest) date in multiple columns containing dates. I have a table that contains inspection dates...

Greetings, I have a question for the group that I hope somone can help with. I have this query I'm wrestling with: The query has a criteria value that...