Hi, all. I'm new to posting, but have been searching the posts regularly to help me build a database for a VERY small engineering company. They have been...

Whenever I create an Access XP expression, if the expression is true, the query returns "-1" as a result. I would much rather that this be "1". How can I fix...

how do I write this expression in a query:Count = 1=$100.00, 2=$500.00, 2=$1000

I'm trying to use the "Right" expression to take a piece of information from one column of data in order to create a new column, but it's not working. Any...

Hi I have a query that selects the middle characters of a postcode: numbers: IIf(IsNull(),Null,Val(Mid(,3))) And then splits the resulting number: code right:...

How do I take a field in access that contains both first and last names of clients, and split them into two new fields, first name and last name?

how do I make a left((x),3) formula into a number format? When I run it as a make table query it comes out as text. I have changed the properties to general...

ow do this in access =RIGHT(A3,LEN(A3)-FIND("\",A3,FIND("\",A3,FIND("\",A3)+1)+1)) A3 being a field in access

My question is to James A. Fortune: Like Mike I have been searching for a way to count occurrences for time off benefits. I found your response...

Hi! I know something in Excel but I want to know something about writing queries in Access. I seek some introduction. I have created an Access table and...

I have a table named D that contains 707005 records. It was built from an imported txt file that contained coordinates and concentrations in two columns...

Our front ends for our data is in access and has all the queries, forms, and reports with linked tables to a sql server back end. My question is when i...

I need to round either up or down to the nearest quarter. Is there a function in access that works like Mround in excel where I can pass it the number and...

Is there an access function that performs the same action as the TRUNC function in excel? The round function doesn't work for my needs. Don't need to round...

Hello, I need to find a way to replicate what Excel does with the Find function. Any help will be very much appreciated Aron

Hello, I need to find a way to replicate what Excel does with the Text function. I have two numeric pieces of data that need to sandwich some text. The...

This is a two part question. I am new to Access SQL having used PROC SQL (SAS) historically. 1) Does anyone know where I can find a site that has a...

I have a query that group by distinct name from a table and count how many arraived to some place (arraived =1 , count how many 1 for each name) it works great...

I am trying to find the average days between orders and shipments for 2001, grouped by employee. Every time I put the fields in it asks for ship date and order...

Hello, Hoping someone can help me out, would be much appreciated. Here is what I am trying to do: I have several tables, each with 46,000 rows of data. I need...