Search results

Assuming CaseID is a text field, try these two queries (replacing with the correct table name in Query1). Query1:- SELECT CaseID, [Date], Value, "Date" & DCount("*","TableName","[CaseID]='" & [CaseID] & "' and [Date]<=DateValue('" & [Date] & "')") AS DateNum FROM [TableName] ORDER BY CaseID...

I'd say the one using Between And and without the need of the CDate() function. But given today's computing power, you can hardly notice their differences. .

If day and month are not always two digits- Left([YourDate],InStrRev([YourDate],"/")) & Right([YourDate],2) .

See the query in the database. Hope it's what you are after. .

Your database contains many tables and queries. It will help if you can give us more details e.g. which table, which query and exactly what you meant by "list all the entry numbers which have a text box". .

You can remove the time field from your Totals Query. Then, in a new query, join the Totals Query back to the table (i.e. by linking the fields in the Totals Query to the corresponding fields in the table) to get the required records from the table. .

You can place the names in a multi-select list box on the form for the user to make selections and dynamically build the query using VBA code from the On Click event of a command button on the form based on the selections in the option group and list box. .

The attached sample database shows how to do it in a query. Notice that the Triple State property of the two check boxes on the form has been set to Yes so that the check boxes can be Null (grayed), Checked or Unchecked. (However, in order to visually display the grayed option, I have to set...

A crosstab query should do the trick. TRANSFORM First(AvgOf3rdNextAvailibleAppointment) SELECT Modality FROM [TableName] GROUP BY Modality PIVOT StartOfWeek; A table has a maximum of 255 fields. So it will work so long as there are less than 255 StartOfWeeks. .

For the Left Join to work correctly, you need a series of two queries. See the queries in the attached database. Run the second query and enter a car cod when asked. Hopefully, you can run it in your version of Access. Just in case ... The database contains these queries. Query1:- SELECT...

Try setting the Default Value property of the two check boxes on the form to False. .

Try declaring the data type of the two parameters (in query Design View, choose menu Query, Parameters...) .

Since the table is not normalized, you can use -Sum() on an InStr() expression for each of the orange, apple etc in a query like the following. And as a table has a maximum of 255 fields, you can type no more than 255 such expressions in the query. SELECT -Sum(InStr([FieldName],"Orange")>0) AS...

To use the nested select statements correctly, you need to use them in a correlated way by means of aliases. SELECT tblNewTrans.Buyer, Count(tblNewTrans.Buyer) AS ["Total New Leads"], (select count(tblnewtrans.buyer) from tblnewtrans as S1 where S1.new=true and S1.[Buyer]=tblNewTrans.[Buyer])...

Try this query (type/paste in query SQL View):- SELECT Reviews.ID, Reviews.Status FROM Reviews LEFT JOIN Results ON Reviews.ID = Results.ReviewID WHERE Reviews.Status="Not Accepted" AND Results.ReviewID Is Null .

A more efficient solution:- FYear: Year([Award Dtd])-([Award Dtd]>=DateSerial(Year([Award dtd]),10,1)) .

Dudley has shown you how to do it in the control source of a text box on a form. As for doing it in a query, please see the query in the attached database. .

DateDiff("ww", [StartDate], [EndDate], 4) -(Weekday([StartDate]) = 4) .

I have attached a sample database, which contains an Orders table and an Order Details table adapted from the Northwind sample. You can open the Orders main form and click on the "Goto order date" unbound list box to go to the first record of the selected order date. The code used is in the...

The first part is rather straight forward. You can simply add NewFieldName: "Current" in the Design View of the make-table query. To add an autonumber primary key field, you need to run a separate Alter Table query after running the make-table query. Something like ... Alter Table...