Hello, Access 2003. I have a single field called "Name" in a table called "Members". There is about 300 records in a Last Name First Name format,...

Hi, I thnk I am missing something obvious, but I an stuck, and seem to need help getting some fields in a table updated. Table 1: R_BSA_M This has fields for...

I have a NEWRATINGS Query which calculates WINNERNEWRATING and LOSERNEWRATING in Calculated Fields. I now want to update RATING (in PLAYER Table) to...

Store # KO# Threshold Start ...

TIA: I have a multi-table query; a child table has a memo field with lots of text. A multi-table query with parent and child table fields with no criteria...

I am trying to accomplish the following in a Microsoft Access 2007 QUERY. I want to evaluate a field called "Cost Type" for the following values and then...

Is this possible in a query? You have Table A Table B There is a link or join between the two tables. Table A is the main table, B is a sub or secondary.

I have a simple scenario... We have a list of 20 items and I'd like people to identify the top 10 to them. I created a dropdown but was wondering if I can...

In a child day care center database at church, I have used the following expression in a PaymentQry to determine a past due amount. PastDue:...

I am a real Novice to MS Access 2003. I am trying to create a query to populate a form to be used as a subform in another form. I have created the form that...

New at this, so please bear with me: I am looking to merge 2 fields unless duplicated. The fields are in the same row in the same table Female Surname & Male...

Hi, New to Access and have inherited a database at work, I need to create some crosstab queries and am unsure if I would be better off creating a new table...

I have a database to manage and track document control numbers and maintain a master document list. I have created an append query for adding new documents to...

-- I hope this helps you, Dan

Hello all! I hope you'll be able to help me out with this situation: My boss is running WinXP Professional, OfficeXP/Access XP(2002); he is using dbases he...

Hello, I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields...

Hello, I am more accustomed to Oracle.... am still thinking in terms of Oracle... Please help me with this issue. I am trying to compare two tables A and...

I don't know of an easy way to do what you are looking to do in Access. I think that the earlier advice to build the sql string in code may solve...

grupy wrote: Id like to know how I can query lets say a specific record from a parent-chil table For example, lets say parent table is Products using...

Hi, CurrentProject.Connection.Execute "DROP PROCEDURE toto" will drop the procedure (not procedute, as in my first message, sorry for the typo).