Search results

It should work ok in both the query and report. For what ypu are saying you should be using something like =DateDiff("d",[first date],[second date])

You can't put calculations in tables, you need to do it in a query. Where you put your claculation in the report depends what it is calculating, totals etc can go in the headers/footers, calculations such as mutiplying a price and quantity would go in the detail section.

Sorry, I can't see anything obvious as to why it won't bring back any results. Just a thought do you leave the form open whilst the query runs? You need to. Can you show me your query design when you use the form to get the dates?

Can you attach a copy of your mdb and I'll have a look?

As well as what Brian said you also need to amend your criteria to Between [Forms]![*WorksOrder Import Date Selection]![Enter From Date] And [Forms]![WorksOrder Import Date Selection]![ Enter End Date] *WorksOrder Import Date Selection or whatever you call your new form with the two boxes on.

You can create a form with two text boxes for the two dates you are searching between, and add a button to run the query using its on click event (form referenced to the query as above).

I don't think you can.

for an input box put in your criteria as Between [Enter From Date] And [Enter End Date] For forms use crieria Between [Forms]![YourFormName]![YourTextBoxFrom] And [Forms]![YourFormName]![YourTextBoxTo]

Group By Person ID and use Max for Appointmentdate

Set the control source of the text boxes to [Enter Start Date] And [Enter End Date].

I use a macro to do something similar. I use SetValue to set the value of the text box to null. Add a line after your Save with the command DoCmd.RunMacro "nameofmacro". Somebody else may be able to do it without macros.

Declare the following function in your modules Function Conversion() Conversion = Replace([Reports]![Nameofyourreport]![nameoftextfield], ".", ",") & "$" End Function Add a new text box for your french field to your report and set it's control source to =Conversion()

Create a macro (SetValue) to set the value of each of the text boxes to null and use DoCmd.RunMacro after the save on the on click event of your button?

This can be achieved by setting some of the fields in your table as required, if a user does not complete all the fields you have marked as required then Access won't save the record. A message box will appear giving them the option to exit the record without saving or go back and complete the...

I do it by closing and reopening the form after saving the record, to the user it looks like the form is being refreshed.

Doesn't matter when you do it, as long as you do it before you run the query.

Add your two tables to the query builder, join them by INST_NBR and PRICE_LIST and change the query to a make table query that'll do what you want.

Managed to remove it using the tool from the symantec site, windows now loads up much quicker :)

Thanks everyone i'll have a look at the suggestions.

When i boot up my pc Norton Anti Virus starts up automatically (it came with the pc) now I'm using a different anti virus I want to stop it running. I've tried looking its configuration and i cant see anything to stop it running, and i've also tried using Add Remove programs but it doesn't...