I'm trying to use an update query to concatenate several text lines into a single memo field with line breaks. I can't seem to find which character to use for...

Greetings. I deeply appreciate the help the MS MVPs have given me (especially John Spencer). I have a quick question about the following query that Mr....

Hi Is it possible to change the column data type in an sql statement I have a table column which is set as text data type. It only contains numbers, but fir...

I have a report which is based on a table which contains one record for each of my reports (title, code no etc), I want to create one query as the record...

I have a query which shows me the following data: Name 2003 2004 2005 Joe 5 6 7 Bob 8 9 ...

Does anyone know how to calculate a percentile in Access' Query? I run reports where I need to show Min, Max, Avg, and a certain performance percentile, and...

Hello, Is their a way to get the top five per each ID. So say each ID has 21 funds, I want the top 5 sales for Each ID. ID Fund Amount 1111 A ...

I have two columns: Job Number and Part Number. Since most jobs consist of more than one part the Job Number may repeat in this column as I list all the Part...

Hello - I have several columns labeled V1, V2 . . . V10. Each record may be blank or it may contain a date in one or more of the columns. I need to find the...

Hi Guys, I have a table that has a number of duplicate entries and want to export the grouped data to a CSV or save as a new table. any ideas? Thanks

Hi, I would like to create a simple function that read IF or is blank "No Data" The OR and AND Functions are causing me problems. I have entered the...

I've got a simple query that I'm using as the source for a report. It has 5 of the fields from the source table in it - Line, DTCategory, DTHours, DataMonth,...

Hi Everyone, Does anyone know how to do this? I need to export a series of queries to 1 Excel workbook, with each query being a new tab. I have pretty...

I have a table that has notes related to records in another table Key OtherTableKey Note 1 2 "Some sort of note" 2 2 ...

Can someone suggest some logic for the following: I have two tables: one gives a listing of items and the second gives a listing of transactions performed on...

Hello, I am trying to count rows returned on a query. The query is on a Yes/No field, and I need to find how many people are "Yes" I have tried the group by...

I enter "103*" in the criteria for a field in a query. The results work fine. When I try to use a prompt instead, as the criteria and type "103*" in...

I have two tables. The first contains 2 columns, ID and Name: 1, John 2, Mary 3, Bill 4, Troy The second contains ID references to the first

I'm new to Access but old to SQL. I want to sum one field by criteria on another field. In SQL, it would be: Select sum(dollar) as Dollar From Table1 Where...