What is the corilation beteen Left and Right Joins in the Join Properties dialog box? I'm working on a Stored Procedure in SQL Server and trying to duplicate...

Being new to access and limited experience with SQL , I'm finding that the execution of queries can be tricky. I'm looking for guidance on how to best...

I have searched the internet and the forums for MS Access and find no answer. When designing a query, my join lines are missing. I enabled join lines but...

I'd like to have a query that would generate a list of dates between a starting date and a finish date, but I can't seem to figure a way to do it! Any...

I want to create unique serial numbers to identify each computer in my organization. I will assign the number to the computer the next time I work on it by...

Hi all. I am trying to count two columns using two variables 11 and "R". I keep getting "This expression is typed incorrectly, or it is too complex to be...

Hello, I've developped a simple database to keep track of student training records. Students are trained on various indexed documents. (The index number looks...

I have an inventory table. The table consist of location, product, tons, weight, request date, pick up date, product price and invoiced. I would like to...

I need to write an SQL statement that will Group by Location and Sum Total Weight Sum Total Tons Sum Total Amount

hi i have a field which stores email addresses in a memo field. i have one query which shows the full length of the field. then i have a another query which...

I am trying to total values which are the same, ie, initials of driver field may have various answers, I am trying to find out how many times a driver...

I have a query set up to count the number of trouble calls for a certain customer grouped by the initial installer. I would like the result to just count the...

I have a query that I am running that changes the text into symbols. I have tried deleting the field and I have deleted the table that I am getting the data...

I have a query that interacts with a form to allow users to create the criteria. Basically, it's a form with drop down controls and a fixed text of ALL as...

Is this the right syntax to add a sequence number to a table Sequence: (DCount("","CompanyTwoYr"," =" & )) Thanks

I am dividing two cells and the results are coming up in scientific format. I can make it look in any format I wan. The problem is when I send it to a mail...

I am trying to create a master select query to manage both US and Asia/Europe employee info. I have live access via linked ODBC table to our US employees...

It appears that my query that has a user-defined function in it will not work when that query is run from code. The query will not run when it is called from...

Hello All, I am using a bit of code in VBA to edit an existing Pass Through Query. I am using the dates the user selected on a form and passing it to the...

Hi All, I have a "datarpt" table :SELECT DATARPT.CP, DATARPT.CODE, DATARPT.NPL, DATARPT.UNIT, DATARPT.A, DATARPT.B, DATARPT.C, DATARPT.D, DATARPT.E,...