I am having trouble with the following SQL statement due to the quotation marks involved. I seem to have a mental block when it comes to quotation marks. ...

I've created two tables; Company Info and Editorial Coverage. I'm trying to link the Company name, address, city, state, and zip from my first table...

Hi , can you help me to make a query that shows only the date of a stock(Date of Last Stock Check) that been from 40 to 59 days I really apreciate your...

i need a query that will return the date (in my case the date of a sample) closest to date X. these are my fields: ingAutoNumber, strSerum#, dtmDate (this is...

Table data: you can see that there are differences after the data is broken down Scan steel receiving Date Kanban...

Hi all, Using this code: SELECT qry_CarrierSummary.Carrier, qry_CarrierSummary., qry_CarrierSummary., Format(CInt()+CInt(),"Currency") AS FROM...

can you lock records in a query or do I have to create a form to keep the users from modifiying some records.

Hello all, I am trying to write an expression (formula) for a Select Query to extract the first group of string. I have tried the functions "MID", "LEFT",...

I have field with Participants ages. I need to get the correct LE_VALUE for that participant. I have 3 fields in one table in my query which are all Number...

When opening my Query, (which used to display information correctly) I now get "Specified field could refer to more than one table in the FROM clause of your...

Hi All, I need to convert a number field to a text field in a query, and I have used format(quoteID, "00000000") This isn't working for me for a couple...

I want to create a query to show me all records with a Payment type = "event" while excluding records with a Payment type of "Donation".

I have a table with a Birthdate field with date/time datatype. I need to have a field in my query that will accept the actual age of the...

What I need to be able to do is to calculate the difference in a value (Temperature) between each depth bin. Then to find the absolute value of the biggest...

Is there any way I can select recors randomly in query? What should I do for that? Any help, really appreciate. Thank you

I have a query with two tables and two fields that make up this calculation The Birthdate field is a Date/Time datatype and the Age of Customer is a Number...

rIs there any way I can select 10 records randomly in query? What should I do for that? Any help, really appreciate. Thank you

Ok... I'm trying to filter data in a report, but still have access to some other pertinent fields. I want to have a query in a report that refers mainly to...

Hi, I am trying to insert a table (tabtest) based on the value(accountno) from the query (qryemployee). This is the query I have, strInputFileName =...

I have created about 10 queries from the same table (they are just numerical totals). But now I would like to display the results of each query in one...