HI I have one table linked to 5 another tables with fis ID I want to search all the ID not existing in the child table I know that I can do: Where (ID not...

I have a database which combines Access 2002 templates for inventory control and order tracking. In it, I have a query based on three other queries...

I need to find the maximum numeric value in a range of 6 fields.

Hello i have a problem i need help on. i can create a query in microsoft access 97 and then link it to my mail merge file. The problem comes when i put...

Hi guys I have a query that I am using to create a list of customers details that I would like to display on a form without using CBF. I would like to write...

or an append query and the table name that was being created or appended to would appear. Now it does not do this. Is there a setting I may have disabled? ...

I Have a Query in Access 97 i am merging into a word document. I can create the Query and Link it through data source in mail merge. But once i go and edit the...

I Have a Query in Access 97 i am merging into a word document. I can create the Query and Link it through data source in mail merge. But once i go and edit the...

Hi: I would like some aditional help with this crosstab query that I've been trying to get working. Michael Walsh responded to my earlier posting, but...

I have the following code to search word docs (ie CV's of Candidates) from access: Sub label49() Dim wrd As Object Dim wrddoc As Object Dim strFind As...

Hi Newsgroup My query work perfect with xp sp2 Home e profesional and Windows 2000 workstation sp4 but with windows 2000 sp4 server a query halt without...

I have a table with 800 records.. I want to write a query to begin on record 1 and output every 4 record.. I also need to be able to change the start record...

I need to extract components from query fields and then group the resulting into two records in the end. What I have is data which contain the word "PAL" or...

We are using an append query to add data from a form to a table (Access 2003). The table field is set to memo datatype, and the query reads its parameter from...

I am attempting to do a grouping on a data set which looks like the sample below. The field name is: "AcctDept_Prod_Cat" and the data looks pretty much as the...

I want to query the Top 100 scores; however, I want the ties, too For example, number 100 has a score of 7490. I want to include the additional 5 records with...

Sure, I am in the process of creating a survey database. For each field (question asked on the survey) I need to return 1. the total number of responses for...

greetings.... i apologize up front as this seems like an "easy to solve" issue but i haven't used access for a long time and it appears that everything i...

Suggestion for next version of Access

Hello, I have an access database that is currently at the DB. Located on the local machines are the .mdb and the .mde. It's only being held off site until...