I have two fields in a query: "Date Completed" (mm/dd/yyyy) and "Time Used (hours)" (nn.n). I want to calculate a third field "Date Started". Assuming an...

I have two fields in a query: "Date Completed" (mm/dd/yyyy) and "Time Used (hours)" (nn.n). I am trying to calculate a third "Date Started" that I want in...

I am attempting to append records to a table. I have a table in my database that contains a member ID. This single field table has a primary key on the...

I have a query call QryFind that produces one field with many records. Simply I need to Concatenate the results to display in a text box on a form. From...

Hello in table I have entries in Field1 that have a number next to them in Field 2: Field1 Field 2 ABC 5 ABC 9 ADD 6 RFF 8 ABC ...

I have a database that has 2008 and 2009 records. I want to delete the 2008 queries. Is there a way to delete multiple queries at the same time? It takes...

I am using the Now() function and trying to use a variable input to go back a couple of days for checking dates. In the Date Column, I am using Date() - 3...

I need to update the domain name in several email addresses. Ex: to be I only need to update the domain name.

I have two fields in a query: "Date Completed" (mm/dd/yyyy) and "Time Used (hours)" (nn.n). I am trying to calculate a third "Date Started". Assuming an...

Hello I have a table which contains start and end points e.g. Start End 1.00 miles 3.00 miles Is is possible for me to create a query to split...

Could someone help me to extend this sql to include: 1. a count of txtsole where the field is a YES/NO field and I want a count of where the answer is YES 2....

I'm trying to calculate the business week by looking at logdate. Below is the entire syntax for the select query with the case statement indented for easier...

My table has a Street address field. I would like to filter out records that do not begin with a numeric Character. Also if possible I would like to filter...

I have a field that is called txtpurpose. The value of this field in any record could be 4 different values " Re-financing", "Corporate Finance", "Buy- out",...

I have a database which has data values in one field where the data contains values that have parentheses which also contain a string (Letter). One value...

cons dcity dst dzip ocity ost ozip e f jk 7789 fg cd 989 c o lk 970 sf9 cdf 9890 cdd yf mh 979 hgg mkhi 7699 cons dcity dst...

How do I write a query that selects the two lowest values for each group? The min function gives me the single lowest value for the entire database.

Hi I am having trouble doing this. Here is what i have. I have a table that shows the date, winner, and loser. I then have 2 queries that counts the number of...

Hi Allen (I hope) I used your code and instructions to perform what I needed to - brilliant .... though I now want to change the default separator from comma...

I have a continuous form with Filtered records. I want to update a single field for all filtered records showing. My code is updating the current record...