Search results

It's Ok we'll get there. Change strcriteria to the following, strcriteria = "RTP_ID= " & Me.RTP_ID

Hi, Is RTP_ID a numeric field? If so you can get rid of the quotes around "'" & RTP_ID & "'" I think you'll also need to change it slightly to Me.RTP_ID

Hi, You could try it exactly as you have typed it or by enclosing it in [] brackets. Your welcome, post back any problems you get.

Hi, What you need to do is to test whether the Reference No the user enters actually exists before running the query. I would do this using DCount and if the count is 0 i.e. that reference number doesnt exist, give the message box message and not run the query or open the results form. Add...

Hi, How about Is Null as your criteria under Case Closed?

Put this as criteria, under Date of Registration field <=Date()-30 and under your paid field "No".

Take a look at the attached screenshot it may help. In my example i have my postcodes in the table postcodes and am only wanting to find records in my addresses table where the postcodes match, so I have joined the tables using an inner join on the post code field. (To join drag from the post...

If I understand you right, create a one column table with the post codes you want stored in it, then create a query joining the table you want to query on with the table you have you created using an inner join. This will select only those records from the table you are querying where an entry...

Hi, Ok for your second question, group by hotel in your query and add a calculated field to calculate the available occupancy something like the following AvailableOccupancy: 20-Sum([NoofGuests*]) * or whatever you call your field that stores the number of customers booked in for each...

Try <=Date() as the criteria under CheckIn and >=Date() under CheckOut , this should just select the current occupants.

Create a query by going into Queries and click on Create Query in Design View, add the two tables and join by account code (to do this click on the account code in the first table and drag it across to the account code in the second table) , then you can put the columns you want to see in the...

Me.Date = Date()

What you could try is 1. Create a query on Table 1 and add a column which extracts the last 4 digits of the SS# using Columnname:Right([SSColumnname],4) 2. Create another query that joins the query just created with Table 2 using right joins on First and Last name and the column you created in...

I think what you want to do is put the following in your query criteria, the text in [ ] will prompt the user to enter the dates >=[Start Date] And < [End Date]

Ok, sorry yes I didn't think it through, that will happen. One way to achieve what you want is to create an unbound sub report based on a query that calculates the number of orders placed and put it in your report footer. I think this will be infact 2 queries, the 1st a group by on order no...

In the report footer add a text box and set its Control Source to =Count([order no]) for the number of orders and add another text box for the number of items with the Control Source =Sum([pcs ordered])

Make it atotals query by clicking the sigma icon in the design view of the query, choose group by for the other fields in the query and Max for your effective date. see attached

Use max effective date?

No you can't, you would need to use a form with text boxes to enter your criteria in or a list box to select names from. Do a search in the queries forum on query using forms, there should be loads of examples of how to do it.

Do you have some form of look up table to convert the numbers to names? If so you should bring this in to the query and join it to your main table, and search on the name from the look up table.