Search results

PLOG - thanks so much - it worked perfectly. I really appreciate the completed code. Ranman256 - Now that i know how the query works this solution will be applied to the form date selection, as you suggested. I really appreciate the help guys! Issue closed

I need a query that will relate values to given date ranges. For Example: Table: TaxTypeRange Values: TaxType; FromDate; ToDate; Contact W2; 1/1/15; 3/31/15; Tom 1099; 4/1/15; 6/30/15; Tom W2; 7/1/15; 12/31/15; Tom Table: Bills Values: Contact; BillAmount...

Trying to change the values in the fields

Thanks Can you tell me what the correct code would be using the inner join? I'll do some tests and see which work better. Appreciate the advice.

Thanks for the reply. Very helpful. I want to do this the right way so I joined the [Checking].[Description] and [Rename].[Description] fields. But I’m having a few issues with the actual code when trying to convert it to the Inner Join method. Hate to ask but can you post what the full code...

I want to automate a find and replace process to standardize names in a table, using the value from one table to replace another. The code I have is not quite working. Background: · Table [Checking] field [Description] has the source text field that I like to change/standardize · Table [Rename]...

I have the following code which partially works UPDATE checking, rename SET [Checking].[Description] = [Rename].[newdescription] WHERE (((Checking.[Description]) like "*" & [Rename].[sourceDescription] &"*") ); Problem is the original [Checking].[Description] value is not deleted in full...

Plog - Thanks. The tests would certainly be conducted; I just need the code to get started. SQL or Macros either way I’m fine – I just need to know what to do. Let me explain better... The [Rename] table has two fields [Description] and [NewDescription], both entered by the user. In...

I have two tables.descriptions I'd like to relate and use to find/replace in bulk. [Checking].[Description] (with the source data) [Rename].[NewDescription] (with the correct data) I'd like the values in [Checking].[Description] to be replaced with the values in...

Thanks for that. So then I have a question - what is the best practice to setup multi-value responses? Each record in the [allnames] table needs to be populated with a varying number of employers - some records will have 1, some will have 10, etc... Obviously one combo box with multi-value...

Help!!!! I have a table ([AllNames]) that a field ([Past_Employers]) is being auto-populated, and I don't want it to. [Past_Employers] population is setup form a form, which references a separate table of employer names [Employers]. If I enter a new record directly in the [AllNames]...

I need to calculate the difference in a stock price from one (user defined) day to another. Being new to access my issue is how to do this given that the records with the beginning and end dates are different and the data is not in the same row. e.g. Key # Stock Date Price 1...

I have a long formula that will be used throughout my database. I assume I can create and name a new formula then reference that name in queries, etc... If that is best practice please let me know and also how to set that up so it is reference-able through the DB. Thanks

I have 4 fields in a table that when combined must be unique. I know you can setup multiple fields as a combined key, but I don't really need these to be the key (I will auto number a unique key). I just need to make sure the same combination of codes is not entered twice. Do I set this up...

Bob Sorry I meant Parent and SubForm are linked through the RequirementID. Not InvoiceID. I assume you wanted the SQL from the SubForm and not the parent? Thats what I sent.

spikepl: The Control Source for the Combo was empty. If I change it to "Status" (the field in the underlying table) then the Subform will not take any updates at all. The Row Source property contains the options in the Table from which the combo reads - in other words - the combo reads from...

Bob -thanks. The SubForm's Status field is bound to a seperate table with a list of options for the Combo Box selections.

All (Thanks in advance BTW), I have a Parent Form with embedded Subform in Datasheet format. The Parent and Sub are linked correctly, with a field called ClientNumber. Each Parent Form has its woen record, by ClientNumber. The embedded datasheets (correctly) show all the invoices for the...

Thanks. I'm trying to set the parameter from the report and not from the query directly. I could be completely wrong with my Unbound approach. Bottom line I guess, how can I use a text field in a report to dynamically filter the report results?

Thanks for this. I see where you are going. Makes sense. I'll give it a try and see what happens.