Hello, As an Access novice, I'm still getting up to speed on proper syntax for nesting queries in SQL. I have 3 queries, the last two of which build on each...

I have one table that gets updated daily by an outside source I created anohter table that never changes however it has some of the same data as the first...

I have two tables with database logins: tblEmployees: tblLogIn: ---------------- ----------- lngEmpID ----------- lngEmpID strEmpName ...

I am working with a database that has 11 columns with the same data type. I need to compile this data into a single column - replicating the data in the...

Hi! I'm trying to show only the text fields which start with "** " - how should I 'escape' the asterisks and the spacebar?

Hi all.. Here is what I have: I have a query that is running a search form. The query is made up of three tables: 1.tblMain 2.tblSpouse 3.tblChildren

I have a table Named Transact_Detail with a field named TR_NO. It carries a 4 diget code like 1001, 1002 then it can go to the 2000 series up to the 9000...

Have a single table which has daily data which I capture on a transaction number basis that falls in 2 general categories. I might have several transactions...

I have two fields in my query from 2 seprate tables. I want to add a 3rd field (I will will manually) by mutilpling the two other tables. Example: Table 1 ...

I am running a query that includes 2 tables and another query. I have one field in a query linked to a like field in a table . I would like this to be a...

I have a opened Date and a closed date and I would like to find out the average time is took to open and close a certain record based on a Area. SELECT...

I need to design a process that will show a rep his/her top ten customers based on sales increase from the past 60 days comapared to the same time period...

I currently have several crosstabs, Querys & Forms. What I need to find out is how to get the zero counts to show. I am trying to add up people assign to a...

Looking for the best way to do something. Best can be easiest or best practice - I'm up for either. Don't need details (not yet :) - just a general...

To begin with, I choose: Modules/New and I paste: Public Function GetLetters(strBookCode As String) As String Dim lngCtr As Long Const conAlphabet As String =...

I'm working on grouping individual records together by families, and I need help creating a text field that is the combination of all records in the group...

I need to implement the following logic in a report column in Access 97: IF hist_mis_cds!typgess = "", then calculated field= "" ELSE IF hist_mis_cds!typgess...

i have an Access 2003 qry "qryP11" Payment ID Employee ID Week Number Pay Pay to date 1 4 ...

I would like to be able to run a query and get a list of ID numbers and from that list of numbers use those as parameters to run another query. Additionally,...

I have iif(isnull(!!),like "*",!!) as criteria in a query field. If I place a value in the field on the form the report that uses the query with the above...