Search results for query: *

ok sounds good.....thanks for all your help brian

Thanks for your help.......I did not even think about not needing the append query. Because you knocked some sense into me, I probably will not even use the append query but if you want to look at it and let me know what i did worng, that would help too. Here is the SQL (it is really big...

I have an append query that takes some calculated values from another query and transfers these values into a table to allow myself to keep a cumulative total of these values for a report. The problem I am having is that when these values go from the append query to the table, the format does...

I have some information that was calculated in a query and that is passed into a report. That is simple enough. But what I need is to allow these totals from the query to be stored (I'm assuming in a table)for use in later reports. Would using an Append Query be the best choice for this or is...

The question is this......I have a form that has numerous time fields. At the end of the form I need to get the total for all of these time fields. For the life of me I can't figure this out. The kicker is that not all of the fields have information in them. The reason I need this total...

I have ran into a snag with a database key field. the key field is case number. The problem that is occuring is once the information is received for the case number the item is given a completed date. Now what can happen (not often but it does happen) is the same case number comes through the...

In my database, when opening reports this error comes up occassionally. It does not happen all the time but it does happen. The error saysm "Run Time Error 2501". I am usind VB code attached to my command button to open the report. The code is as follows...... Dim strReportName As...

The problem that I am having is if you cancel the parameter instead of inputting information, the whole database shuts down and it goes to the database screen? Why is this happening and how can I fix this? Thanks, Brian

Is there any way to add a command button to a report.....I can't figure it out. Any help will be great. Thanks, Brian

Is there any way that instead of having to input the date that at the end of the field there can be a calender that you can clisck on and select the date you need. Any help would be great Thanks Brian

What I need is for the report to show information a certain way. In the main table the information is stored as "yes" but on the report I want it to show an "X" if the data is yes and show nothing if the data in the table is "no". Thanks, Brian

What I need is for the whole line in my report to be a color if one of the fields in my report has a certain peice of data. Example: Sales Rep is Dave......then the line in the report that has Dave needs to be blue. I was thinking of conditional formatting but that seems to be a rather...

A little backround: I have a main table that has 30 fields. Now I need to make a report that shows all 30 fields, but here's is the kicker: One of the fields is "Actual ship date". What is needed is for this report to show all 30 fields but once "actual ship date" has a date inserted in it...

This seems like this problem should be easy to fix. What i am trying to do is to have my query show the users selected date range. I keep running into problems with this, I figured that a parameter would be the easiest thing to do as it prompts the user for the dates that they need. The table...