Hello, How can I query / count duplicate values in a single column? Thanks, Rashar --

I have searched for this but can't find any examples relevant to what I am looking for. I have a web application that uses 2 listboxes so that the user can...

I need a query to report 2 columns of the same field, but with different criteria. Example: Criteria of "Like16" and Criteria of "Like 17" This way...

Hi, I am using Access 2003 on a PC with Win XP, 2Gb RAM, etc., etc. I have a table with 4 columns, and 73,766 records: ID: Autonumber Row: Text (to be used for...

I have an append query that will not work and causes all the records to be rejected because of validation rules. This is the SQL view of the query I bult with...

so i followed these directions from Sidney Linkers and it works...

Hi, I have a query called qryCustomers. I have a combo box called cboShip_Month. When the user selects Jan in the combo box, a 1 is placed in my table under...

Sir/Ma'am, I have a query that searches out specific records by date. The query works the only problem that I am having is when I run the query and it prompts...

I would like to have a Query that the user will only need put in the month and year and the Query will only give them record that fall in that month. Jan 2005...

I have a database in which I store some date and times. When from Excel I use the MSQuery Tool to return the information it is bringing the date and time back...

In palin English, I have a table based on club members and several other fields of numeric data. Some of the fields are numbers, some currency and some text....

Dear All, I've tried to research this question, but maybe my terminology is wrong.... but basically this is what I am after... I have a table which includes...

When creating a query, using the simple query wizard the linking of all tables are done correctly. However, when designing an existing query the tables that I...

on a continuous form with the record selctors on, can the record selector icon be changed from the asterisk to something a little more application specific...

I've used a database for a year, many users adding info to it. I've written many queries and they've worked beautifully. This week I've been getting a "record...

I am trying to split on field into three in a query, Redgum QLD 4850 Newcastle NSW 2300 Rye VIC 3950 Mount Victoria NSW 2710 Perth WA 6000 Glenelg SA...

Hello. I have a union query that returns the correct records. I want a count of how many records are brought back. After moving to a union query I'm having...

Greetings For a union query of two tables, is it possible to include the name of the table as an additional field for each record, so that I know from...

Field 1234 Anywhere St #29 34 Anywhere St #345 1 Anywhere St #1 How can I extract the Street Numbers from the above records? I only want the prefix numbers,...

Hi, I have a simple table to record a range of jewellery with an image for each variation. The fields are Item, Pattern Number, Stones, Image (Picture)....