Using Access 2003. Using a query. Have searched this database and tried several things but not close enough to my situation. I new at this. I designing a...

How can I get this to round up show dollar amount only, whole number no decimal places? Income: Format(Sum(CCur(Nz(,0))),"Currency") Example 1.32 = 1 1.5...

I want to put all of my data into one row so that when I use that data for a report, it's going to print in one row. What's the best way to do this? The...

Hi, I am trying to find duplicates from one table using one column as the criteria. However, some of the value in the column differs from one and another,...

Hi, I am new at access and I am trying to add a column that shows the same number in each row. IE. The year 2007 all the way down the column. Is there...

I have a query based off of two tables. There are date fields in each of the tables (class date and enroll date). The query includes each of the date...

Hi, I'm using Access 2003 I've a query which feeds a report and i'm using a form with a drop-down allowing a user to select a criteria to filter the...

Hi All, I think this should be easy, but it is not to me anyway. In order to test the functionality I have build a very small scenario: One table with two...

I must filter out in my query all Clients who have animals or return all Clients depending on whether the Visitors form shows either Yes or No in the fear of...

I feel that this question must have been asked before but a google search hasn't found anything. Apologies if it's old hat. I'm correcting a database (hah! 1...

Hi all, I have an enrolment table for a local continuous enrolment, alternative high school. Using the StID field, the Course field and a course end date...

I need to see in an query how to change: 2021987 (feb 21,1987) to be 02021987 (mmddyyy) I woudl appreciate anyones help - im so new at access -- Buck

I would like to be able to group consecutive SortID's by SortType's T1, N1 and P1. For instance, I need to be able to group SortID's 12123, 12122 & 12121. ...

I have Office Professional 2003, and kept getting an invalid use of vertical bar when attempting to look at a query in Design view. I am able to open the...

I have a fairly basic database consisting of two main tables - clients and assessments. In a nutshell clients get periodic assessments in which they are...

Hello, New to access and I am looking for help with a query. I have a query that currently is bringing back all the values in the table. There could be up to...

Hi All, I am using vartype to debug 'empty' data fields and would like to display the description instead of the value. What is the easiest way to do this in...

This might seem a bit absurd in the context of SQL, but I'm wondering if anyone has felt the need to "step through code" in a manner similar to that which...

I recently upsized my MS Access BE to an SQL server. Everything seems to works great with the exception of a few queries (other queries are still working...

I have a table containing serialized customer numbers that have to be in the range of 1-9999. It has to be 1-9999 because it has to be exported to an older...