Search results

I have a query that selects two fields and they must be Distinct, but I want the recordset to come sorted by a field I do not select. Is there a way of accomplishing this doing a sub select? Or some other fashion? Here is my query that I have right now sSQLQuery = "SELECT DISTINCT [Bill...

Copy records with a new AutoNumber [Resolved] I am trying to do the following statement sSQLQuery = "INSERT INTO Test SELECT * FROM Test WHERE [Flight #] = 'LOUNGE'" cn.Execute sSQLQuery This will basicially make a copy of the records that have a flight number of Lounge. The...

Storage Space [Resolved] When you set up a field as text it also allows you to setup field size. If you set the field up to 20 characters opposed to the default of 50, does that mean that it takes up less hard drive space or it is just a way to control how many character a user can put in?

This Record Already Exist? [Resolved] Why am I getting a "This Record Already Exist" error when I am just doing a query? 'This query works prefectly and I get the results I want. sSQLQuery = "SELECT * FROM Prices WHERE KitchenID = '" & txtKitchenID _ & "' AND [Customer ID] = '" &...

Sub Query [Resolved] Does anyone know if it is possible to use the DISTINCT keyword on one particular field, but yet pull up multiple fields in the query? Or another way, where your query will pull up records based on any unique value for a certain field, but also pull up a bunch of other...

Updating a boolean field [Resolved] Anyone know why this does not work? sSQLQuery = "UPDATE BackOutBilling SET Report = " & True & " WHERE [KitchenID] = '" & sKitchen _ & "' AND [Report] = " & False The field Report is set up as a yes/no field.

I have never did a report before and I was wondering if someone could give me some help setting it up. I am attaching the database that includes the table that the report will be using. In the report section I also have a report that I have been working on but I need help in finishing it. Also...

Indexing and sorting [Resolved] This might sound ridculous but I want to make sure. I have a table where I have several fields set up as an index. So originally the table was sorted according to those indexes. Well I resorted the table based on one field because it make it easier for me to...