A thank you to Karl Dewey my post using wildcards on a keyword query. Works great --- thanks again. This is really a great resource glad a friend told...

I have a list of admissions that includes a start date and an end date. I am trying to produce a list to show the number of members that are current. I have...

Hello .. I'm not sure where to post the following. Originally I posted it in the general access newsgroup but have had no reply .. apologies if this is also...

Hi. I am having trouble creating a query that will bring back the results I want. I've set up a table that contains: DuesRateID, EffectiveDate, and...

Hello, I have a make table query I have set up. It ran perfectly yesterday but upon coming in today it was giving me a Unknown Jet Error. When I clicked...

I have a parameter query and I would like the dialog box that comes to be a combo box to show me the possible choices to enter into the field for a search. ...

I have created a simple database for our church cemetery, one table tracks the plots and their useage (ie: someone interred, reserved or vacant); one table...

I'm a newbie trying to create the # of working days either in a query or via a report between the date something was received & the date we finished it. ...

Hello all. I have several queries that i need to add the uniqueID field to so that they can be shown in reports already setup. When i setup the queries i did...

Hi, I'm hoping someone out there knows the answer to this one! I've currently got two tables that I'm trying to join. However the two fields that should be...

Hey i have a table which contains new orders information includes date, model, quantity, cost , total cost. I need some way of calculating and displaying the...

Hi, Have a simple question......... select * from mytable inner join myaccounts on mytable.id = myaccounts.sub_id where mytable.party = 'shripal dalal' and...

Hello, I have having trouble with this query, and am not sure how to go about it. In my table that's linked to another shipping database, I have a main order...

I have a query which contains a "Curr_Amount" column that has numbers, a “Prev_Amount " column that has numbers and also a"Difference" column that is...

Hello, Can someone offer help on a database problem I'm having. The situation: Training database with associates table, completed training table, certificates...

Alright, I have eight fields in a record, all numbers. I need to build an expression that will determine which one of these fields contains the greatest...

I'm tryimg to return record to view yearly production performance. Then creating a line chart based to the record returned.Then I modify the query builder...

Sorry for the subject description, I hope I can better explain my question here. I have a access 2003 database with related tables. What I am trying to do...

I have the following query Regarding Microsoft Access Db. We r using Access Db for an Web Application ..... The application contains the different...

My Switch is getting too complex - 14+ cases - and I have a couple more cases to enter. But it explodes if I try to add more. I can't use a lookup...