Search results for query: *

PHV, It looks like it would work, however, I am not use to writting queries into access. Also, what is being referred to as NewMonth and field 2? Thank you for any and all help, PBrown

I need to copy all records that have the highest number in the [NoMonth] field. I.E. If the table has 168 records, with a value of 1 in [NoMonth] for 100 records, value of 2 for [NoMonth] for 8 records, and the remaining 60 records have a value of 3 for [NoMonth]. I need to have a button...

Basically what I need to do is copy the records that have the highest (Max) number in the [NoMonth] field. However, when they are copied, they need to be pasted with the [NoMonth] field increased by 1 so that it is distinguishable that they are for the next month. I was using a "duplicate...

I have gone in and changed the column (field) name from Month to NoMonth throughout the DB. As for the where clause, I have tried placing: [Forms]![mprsummary]![Month] in the criteria for what is now: NoMonth: [Forms]![mprsummary]![NoMonth]+1 However, now when the append query runs it does...

The append query is performing the "Copy" function I need however it is copying too much. Currently in order to have the append query automatically add 1 to the month the [Month] field in the query is: Month: [Forms]![mprsummary]![Month]+1 However, this causes the query to copy all the...

Currently when the user enters the form if there is a record they want to copy they go to that record and click the "Copy Record" button. However, what is happening is that they are having to go to several records and click the button. Each of the records have a common value in the [Month]...

I have a similar situation that perhaps someone could help with. In a table (tblemployees) there are the fields [FN] & [LN] (First and Last Name). Also, in the table a new field of [Name] has been created. Is there away to run a Update Query to have Name = [FN]&" "&[LN] ??? Thank you for...

Here is the current table structure: (this is serverly downsized since there are a total of 97 fields) [Area] [Facility] [DirectACT] [DirectBUD] [DirectVAR] [SemiDirectACT] [SemiDirectBUD] [SemiDirectVAR] [IndirectACT] [IndirectBUD] [IndirectVAR] [TotalACT] [TotalBUD] [TotalVAR] [ManagerACT]...

I guess the crosstab coding is just too complex for me without any assistance. I have gone through many different FAQ's and even different Access Books but am unable to understand how to get just the query working. Any assistance would be greatly appreciated..... Here is some more detail if it...

Tried going through the crosstab FAQ, but seem to be missing a step or two. I get many different columns but honestly can not make to much sense of it. Can a crosstab query be used when dealing with only 1 table, because that is all I have. Guess I will continue to experiment if you say a...

I will have to re-visit the FAQ. I would like to thank you for your understanding. Thank you for any and all help, PBrown

I guess I do not fully understand the question? I was able to get everything BUT the totals column to work by using the KB article. Now, what I need is for the totals column... Once again, exuse me if I have misunderstood the question. Thank you for any and all help, PBrown

Thanks! The report is now going as planned. However there is one item that has been "requested". Since the report is now in the correct "Column & Row" format is there anyway to instruct Access to have the final Column in the row to be a "Totals" Column? I.E. [Area1]...

Some background... There are areas that are reported on, and in an attempt to format the report as everyone is use to in Excel I have set the report up to have columns. The detail has 3 fields... [ACT] [BUD] [VAR] Therefore the report currently looks like [AREA1] [AREA2]...

Tried: Private Sub Form_Load() If Forms![Switchboard2].Facility = "CA" Then [Gulf].Enabled = False End If End Sub Also, Private Sub Form_Load() If Forms![Switchboard2].Facility = "CA" Then Forms![Switchboard2].[Gulf].Enabled = False End If End Sub However, it does not work either. Could...

I would have thought this would be rather easy, but Access has other ideas... Basically, (2) forms. Switchboard1 Switchboard2 Switchboard1 has (3) buttons TN MS CA Switchboard2 has an unbound text box named Facility When the user clicks (on Switchboard1), TN the unbound...

The only worry about basing the form via a query is that the form has a subform. Will that affect it in anyway? Thank you for any and all help, PBrown

[Date] in the order by does not order the records by date. I still have 2/24/04 and 2/25/04 being mixed together...... Any other ideas? Thank you for any and all help, PBrown

When the form opens it shows the records according to the order they were entered. However, I need them to show in order as to the date in the field [Date] then next ordered sequencially as to if the record was: Breakfast Lunch Dinner Example (I know the dates are wrong): If the user enters...

The problem is that this is on a FE. If I "add" it to my dictionary or ignor caps on my FE or the FE before it is distributed to each PC will it still work? Thank you for any and all help, PBrown