I have a DB that we have been running for years. It has several customers and they are listed by their system serial number. When I open a ticket for them I...

I have two queries which i wish to compare to see variances ie rows which are not on both run queries what would you recomend for me to achieve this. Many...

Hi, I hope you can help me. I am trying to write a query where I can search two fields and bring back the results ( by last name). The fields names are Owner...

Hello: I need to run a query able to find duplicated data within some field. I tried filters but my DBase is too large and this task became time consuming....

I have two tables each with 3 fields. a primary, a text and a ole. I want to update table 2 with table 1 data. If I only update the text field there is no...

I have a relational query that draws from 3 tables - I find that 2 of these tables has a field named and I need both of these 2 different phone fields in...

In a pre-existing query, under the criteria, I see "word processor" What does mean, exactly? I have looked through all the materials I have, and...

Does anyone know of a good freeware tool or add-on for access 2003. So I can run queries, check records, search/ filter etc in a more user friendly way than...

A coworkers database is showing problems when querying the ID (autonum, long int) field. For instance: SELECT * FROM tbl_ref WHERE code=237 will not return...

Hi! I hope I have this in the right discussion group. Here is my problem: I have a form which is to be used to enter query criteria for up to 14 fields. I...

Hi everyone...I'm doing some simple data analysis (ie: no VBA) and found a weird anomaly in the criteria field. I’m using multiple criteria in a string...

I lost my query design grid-it is not showing up. I can only see the selected tables and relationships in the upper part of the design screen - any idea how...

Hello, I am in need of some advice for a table create query. I have to work with a database that is imported using XML from an online database. Unfortunately...

I have a query that produces the results: PorS AgencyName MailAddress P Adam Miller Agency, LLC ...

How can I adjust the vertical size of query and save it? In older versions of Access XP, it is enough to make position height by mouse-drag and save. When I...

I have a query that I'd set up a while back for a user on an Access 2003 db. The main table has keys that point to other tables (schools and departments). She...

Any help would be sincerely appreciated, I have an Access 2003 MDB that works fine under fully patched WinXP system. However the same 2003 MDB is throwing an...

Im using ACCESS 2003. Ive created two queries using Query Design wizard. Now what the problem is that, i want to bring the result of those two queries as...

Does anybody know where I can download access 2003 runtime? All I keep finding is the 2007 runtime which I don't want. Thanks, Jasper

I have an application that runs well under "Access 2003". When executed under "Access 2003 runtime" some criteria of the query that supports the sub-form ...