When I try to make a field the primary key and save it, it tells me that I can not make a field with a "null" value the primary key. It says that on all of...

I am new to writing free hand SQL, and have a two part question. #1 relates to sub query consolidation and #2 relates to SQL syntax and why it...

I am attempting to use the following dataserial syntax to extract records from the current month and year. Between DateSerial(Year(Date()),Month(Date())+1,-1)...

I have a field called ID and the records look like this: a1, a2, a3,...a11,b1,b2...b12,c1..z199 When I try to sort, it gives me the following: a1, a10, a11,...

Is there a way to write a third query that shows the records on a form to be from using either query 1 OR query 2 depending on which query was run? That is,...

I have a table that has a company name and 8 different ratios for the fields. (nine fields in total) What I want to do is run a query where the results will...

Hi - what is the SQL syntax Access to return the top 'x' rows from a query? Thanks --------------- Luke Bellamy Newcastle, Australia

I am looking for a function to calculate stdDev of a group of fields, rather than a group of records. The data looks something like this: part Jan Feb Mar...

Hi I have a table called Accruels. In this table are several fileds were payment can be split. eg CompanyA, CompanyB, CompanyC etc. There are 9 fields. These...

I am trying to query a db containing a long date for the following information: 1. Weekday name for a particular date 2. The date for the first day of each...

Hello, I have 2 database, One with vehicule data and another with All the option each vehicule has. I want to build a report that will show me the most...

I have a database field that has data like SVC-St Louis. I want to trim everything left of the "-", including the "-". How do I do that? Thanks in...

Thanks to everyone for your help. Doug Steele, this is the next stage in the problem you were helping me with yesterday. By the way, I got the table to...

I want to hide the colums that return empty fields after running a query, for example. 20 fields for one persons record, only 5 have data in them so the query...

In my query I made an expression to show month and year. However the value of the year returns in another value. The value must be 2006 but shows...

Hi I've a question I need to distribute on cd a static version of a my interactive site (made by ASP), I need a tool able to convert and manage link...

Greetings all, I'm having trouble refrencing a combo box in my form. typically I use a text box and refrence the text box with ! But now I want to use a...

Sample: select u.username, u., j.job from userLogon u, Jobs j where (u.username = j.username) and (u.username = 'certianUserName') I have seen the above...

I have a table that has two fields; odometer reading and reading date. I want to able input the reading dates along with the odometer readings. Then I want my...

Why would a new query, just ran, be read only. Any time I try to delete a record, it says that "data is read only". Any one that can tell me why please...