How can I count the number of times the @ symbols appears in a text field.

Hi, I often use aggregate functions in a non-grouped query when I'm writing queries in T-SQL in an Access .adp server link. However, when I try the same in...

I have two table linked on the field 'Range' and the following query returns 'Field' values in one table that aren't in the other. SELECT DISTINCT...

HI...Let's say I have 2 tables, tblRangesA and tblRangesB, each with just one field 'RangeName'. I know tblRangesA contains 5,110 distinct values, and...

I have a simple SELECT query which is based on two tables with an INNER JOIN on the VehicleID field. I noticed however, that if I added another table to the...

I'm slowly learning SQL and have been setting myself small tasks/problems to solve as a way of doing so. One of these was to count the unique values in one...

I'm slowly trying to learn SQL in Access. Probably the usual way - for every query I build with the QBE grid I then switch to sql view and get to grips with...

I have a simple table with the following fields: ModelType text ModelID number SaleMonth date (mmm-yy) SalePrice number The table contains approximately 150...

Hi, I have a table containing transaction data which includes a 'SoldDate' field. This table contains records relating to all days of the week. However, I...

Can anyone recommend any good reference books for learning SQL. But only as it relates to Access (baby SQL as it's referred to at work). Any recommendations...

Hi, I need to create a query to select dates that are between date 1 (1985-11-04) and date 2 (1985-11-11). Currently no records are showing up when I do...

Hi, I'm using an access query to attmept to see if somebody meets a specific age requierement. I need it accurate down to the present day. I tried...

hi, is there an expression i can use in peoplesoft query to return the exact age of person using the Birthdate field? thanks.

Hi: I have a Query that has a WorkID and a Work Description: ID: Description: 1 Go to work 2 Come home 3 Eat Dinner I want to compile the Descriptions into a...

Thank you for the feedback; I appreciate your help and the suggested modifications, they are much better. I still have some questions that I need help...

I took both of these if statements from a query in an access database and I am trying to interpret them. New Request: IIf(IsNull(!),0,!) Old Request:...

I need to find out the previous date than to the maximum date from a date field

I have created a query and trying to combine two tables into one. One table has all of the information that is needed, however, there is one table that has...

Access query fails saying out of temp space running a query that will create an Excel spreadsheet of 17,000 lines or so. However, after about 20 minutes, it...

I am looking at a field from a query that is in design view. Inside the field are two field names from the same table which are separated by a colon. For...