Search results

Hello, I'll admit that I haven't used Access in quite a while. I am trying to insert a field into a existing table from the main menu. Once I have highlighted the column that has the data attributes of the new column that I'd to add (Yes/No button options), I am unable to locate the "Table...

Hello, I am trying to create a query in Access 2010 for records that don't match based on the following criteria. I have two tables with identical ID's and I need to do a comparison on the amount field between both tables and only return the records from one table displaying all fields plus...

Hello All, I'm using MS Access 2003. I have a report that sorts alpha ascending but I want one the sort fields to be appear 1st and then ascend the remaining. For example the field that is being sorted at the second level starts with an "F" and the first level starts with an "E". I want "F"...

:oI have a large voucher report that consists of about 250 tabs (separate offices) in an excel workbook. Does anyone know of a of way to email only one report "tab" via MS Outlook after opening the work and selecting only the report tab that a user would like to distribute without the email...

I'm not sure how get negative numbers to appear in parenthesis. I used the Format function inconjunction with the Sum function to aggregate a field called "Net Difference No of Claimants" that exists in a table. I've tried variations of the following function; =Sum(FormatNumber([Net...

Hello, I am having a small problem inserting a 0 in a text field that contains a date. I work with large amounts of data derived from other systems and I have to format them to meet the requirements to be feed into others. I need a query that will only insert a 0 to the single digit day within...

Hello, I'm having a small problem converting a select query I wrote into an update query. Below is my original select statement: SELECT Mid([address3],1,InStrRev([address3]," ")-4) AS CITYx, Mid([address3],InStrRev([address3]," ")-2,2) AS STATEx, Mid([address3],InStrRev([address3]," ")+1,10)...

Hi I'm new to query writing and I'm needing help with a query that will search a field that either contains a name or an address and only return fields with addresses. Select address1 From Booktable, Where (Left([address1],1) = Like "[A-Z]" Thanks in advance for any help!:D

Hello, I'm attempting to use a case statement in order to select fields from a column that have names and addresses mixed. I'm wanting to select only the fields that contain names. For example some fields start with an address of "1998 Sky Rd" or PO BOX, or Suite at the beginning of the field...

Hello, I'm writing a query that will append to a table and also convert it dbase IV. The problem that I'm having is controlling the actual field width size when the new table is created as dbase IV for foxpro. It creates every field width size as 256 and I'd like to know to how controll the...

Hello, I'm having a problem writing a query with nested iif's. This query is suppose to manipulate a text field that with #'s. Each field is either 5 or 6 characters containing a date such as "20607" or "10607" which is in the mm,dd,yy format. Can you have a nested iif statement such as below...

I'm examining a previously written query and I'm trying to figure out exactly what the minus sign does when placed before the Instr function. An example of a query that successfully flips a name field is below and includes the -instr function. I've also included another query below this one that...

Hello, I am trying to write a query that will search a field for a string until it discovers a comma. If there isn't a comma I want the field left as is. If there is a comma I want it to grab all strings before the comma and then take the string after the comma and flip the arrangement to...

Can some help me with a query in access 2003 that looks at dates in this format example: 10/22/2007 and changes them to 10/22/07. Thanks a million in advance!!!!

Hello I'm having trouble getting my nested Iif statement to run. Can anyone help??? I've attached a screen shot of the syntax error that I'm receiving. The example code below needs tweaking. Update [Goodrec-copy3] set [Goodrec-copy3].shortname = Iif (Not...

I'm new to writing nested iff statement. Can anyone help me understand the how to write arguments to avoid syntax errors??? I'm need to write multiple iif statements with arguments that will not change/ignore a field that has a current date displayed MM/DD/YYYY but will flip fields that have...

:mad:Hello I'm new to queries! I'm having a problem writing an update query that will look at a name field ie (Dan Wilson Sr) and flip the name to a shortname ie (Wilson Sr Dan) with the criteria based to only flip the name if it contains Jr or Sr. Below is an example of a select query I was...

Hello, I'm new to working with Access Iif statements. I'm attempting to change data values in an existing table for column named "Status." Some of the data in this column has the correct value (Active) that needed represented, while the rest is populated with either a "J" which is Active or "T"...

I'm wanting to run an update query but first I want to see the results by using a select query to make sure that I'm getting the correct results. See the following query statement: SELECT ([Goodrec - All] INNER JOIN WH_ACCTCOMMON ON [Goodrec - All].ACCTNO = WH_ACCTCOMMON.ACCTNBR) INNER JOIN...