Search results

I created a table with high/low values for the categories and used a between function.

Thanks. I have eight queries (one per week) so would this create 4x that many? I am a newbie so bear with me! Would Excel understand if I had the Category field look for a matching range in a table or something instead?

I have added this to a query Category: iIF([Number of total miles for this week]<=15,"turtle", iIF(Eval([Number of total miles for this week] Between 15 And 36),"fox", iIF([Number of total miles for this week]>=36,"lion", " "))) It functions as expected in Access. However, when I try to...

:eek: :banghead: Thanks for the proofread.

I have two combo boxes on a form. I was trying to follow http://www.fontstuff.com/access/acctut10.htm Example 2 for single source table. My source table is qryAdminCoFarms with columns [Admin County] and [Farm Number]. However, instead of the second combo list populating, I get a parameter...

A coworker suggested doing it within the queries I already had, rather than doing the update method. It worked! Thanks!

I guess I need to save more often or something...thanks anyway!

I have shared this with a coworker with much more experience to try...it's over my head! She may be chiming in. Thanks.

Is there a way to print the date/time information from a linked to file on a report? Example: The linked file was updated yesterday, and has a Windows Explorer date/time of 03/17/19 12:01 PM. I'd like that info to print on my report so they now how current the data is on the report, rather...

I have created and recreated a report because it breaks after I close the database. "...can't open the form..." "It contains data that MS Access doesn't recognize. Re-create the form or, if you maintain backup copies of your database, retrieve a copy of the form." I am displaying data...

I had to do two separate update queries. Otherwise I got syntax errors. I think it is working correctly now! Many thanks!

Any ideas why the update query fixes the blanks but not the sorghum name? Thanks.

UPDATE NAP_Crops_Dupl_Table SET NAP_Crops_Dupl_Table.[Crop Name] = IIf([Crop Name]='Sorghum Dual - Purpose',"Sorghum, Dual Purpose",[Crop Name]), NAP_Crops_Dupl_Table.[Crop Type] = IIf(IsNull([Crop Type]),"NONE",[Crop Type]); The "NONE" portion works to get rid of my blanks, but the name...

I noticed that two of my items are not listed the same in my linked tables. Is there a way to use a query of a linked table to replace the name so it matches/standardizes? Could I do that to get rid of the blanks by replacing them with 'none' using a query?

I got it to work with ` marks, but now I get a syntax error in the Join. Will mess with it again on Monday I guess.

Thank you. My table names and columns have spaces in them. I'm guessing that's a problem? I get a syntax error.

Can you tell me about the order portion? What does that do? Thanks

Sorry, yes all 4 columns must match. I assume this is something I would copy/paste into SQL type of query? Not to be obtuse but I am really new and self taught at Access! Thanks!

T1 is all possible items that can be insured in that location by type and purpose. QP is all items that have been purchased at that location by type and purpose, along with additional data about the purchase (i.e. amount and customer). They don't have unique identifiers, although each record is...

So for query 1, I just removed the Type from my joins, and it returned the ones with blank types along with lots of items that are not insured. I am a newbie, so please bear with me. I don't know how to query 2. I have a table of insurable items by category and type. (TI) I have a query of...