Search results

I have an update query, which updates my field(Confirm) in my table to yesterday's date and puts a checkmark in my yes/no field. I have another date field(Changed) that I want to compare to my Confirm field and see if the dates are the same. If they are not the same I want to take the...

I always do my calculations in my query. Do this in your query: Units on hand:Sum([UnitsReceived])-([UnitsSold]), then put the field Units on hand at the footer. :)

Group your query and make it show last :)

Put this in the input mask : 99/99/00;0;_ Or you can go through the wizard and it will give other choices! :)

Do a search on "Expressions in queries" in the forum, you will probably find what you are looking for :)

Have you tried putting your calculations in your query? If you do that, then it would be a lot easier to do what you want to do.

You can go to the linked table manager and point your tables to the right direction :)

Why not:confused:

Make another query out of your crosstab and do the nz function there and see if that helps :)

Change the default view of your form to Continuous or Datasheet forms then you'll be able to see all of your records :)

Go to page set up and under the column area tab change the number of columns to 2. :)

Refer to this posting: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30745

Go to page Setup again and change your column layout at the bottom to Across, then down. You can even change your column size to make the layout look better. I hope that solves your problem :)

My guess would be your subreport is causing this. Make sure to check for can shrink and grow properties in your subreport in design mode in your actual report. Reports are very tricky;)

Also set your can shrink and grow property to yes and play around with it, that might be causing it too.

In your detail section select all and move everything down and see what is causing it. Even if one of your lines or text boxes is bigger than the line the space will show:)

That's Microsoft for you:D

I am just curious to know if you are using croostab query to get the information. You said in your first email that your report looks like crosstab. If that is the case, you should create a crosstab query first and run your report based on the crosstab. Then you would be more flexable as far...

I see what you are saying now! If you put your graph in your detail section, it will be repeated 9 times or however many records you have. The best way would be to split your report to 2 columns and use the space that way too. Going to File/Page setup and change the column to 2. Then you can...

Anything is possible! Yes it is possible to put a graph there. Are you going to be using the graph as a subreport? Reports are very flexable and if you play around with the size of your fields, you can stick pretty much anything you want in your reoprts. I hope that helped!