I have 2 tables 1 of the fields in one table is comments but is not in the other i am running a query to match users from ID Name etc but not comments the...

Access 2007. Often I create a query based on several tables, and have to split up the work of the queries into subsequent queries so that the evaluation is...

Does anyone know of any downloadable programs that can be used to send free SMS messages from a computer to another persons cell phone?? Thanks!!

Tried to download two new versions of this to replace the one i had which was not functioning and now none of them work!! What can i do to fix this??

Hello. I am a new here and have found this resource to be vastly informative. Much thanks to everyone. With that said, I am struggling with the following...

when a numerical query returns empty how do you make it show as 0?

Haven't had much success on my own so I hope this makes sense... The Row Heading is a Part Number and the Column Heading is a Type. The Type column is my PIVOT...

I have an Access Table that will be updated often. I can put the Timestamp on the records but what I need to know is how to Query only the last records entered...

I have a table that is updated often during various times of the month. I can set a time stamp on the records when they are entered but how do I only get the...

due to a jet engine error (80004005)i have changed the date format in my db from short date to medium, however, when i run a query the criteria (Now()) or...

Hi, I've got my duplicates records query and now I want to delete these 1100 dups in my table of 12,000+ records. Can you please explain how I can easily...

If I have 2 recordsets, both which contain identical fields, is it possible to merge them into 1, before displaying them on a report? Thanks, -David

I have the following code on my report: Private Sub Report_Open(Cancel As Integer) Dim PONum As String PONum = "1276" ' Sample number for testing Dim db As...

Here's the scenario: I query my database and put all of the records into a recordset In the recordset is a text field which I parse with a regular...

Any workaround for this? Can populate a regular query from the results of my pass-through to make it work? -David

Is it possible to batch multiple queries into one pass-through query? One table is local the other on sql server ie Select a.id from table a inner join table...

I have a table that has one field of primary stock numbers and another with a substitute stock numbers for the primary stock numbers. The way table reads is...

I have a field that the last character is sined. I need to apply the IF Statement below to convert the sined field. If the last digit is { then value should...

I need to do a comparison query based on a field that sometimes contains 12 characters and sometimes contains 13 characters. I need to ignore the...

I have a table that houses information on supplies. Each supply has its own stock number and status code. I have duplicate and triplecate stocknumbers in this...