Search results

I have a query that prompts for a name and then searches for all records that have that name.How do i make it so that it returns all records that have just part of what was typed in in the name field. For example if just "rich" was typed in all records that have "richard" would be returned?

Hi I am stuck and really need help. Access 2000 Have a query that shows me details of all invoices between two dates. Now I have created a report based on this query, where by the details are ordered by date. Is it possible that for each date the total of all the invoices for that date can be...

I am sure there is a simple answer to this(well i hope so) I am creating a report that is an invoice. It is based on a query that selects an invoice number and shows that invoice. However at the moment, in the report all the invoiced products are appearing on seperate pages. I have their labels...

I am currently developing a stock control system on Access 2000 One problem when I record a product order and it is saved I want the database to automatically update the Product table to increase the "on-order" record by one, then when it is recieved decrease it and increase the "in stock"...

Wonder if anyone can help. I have just created a subform for a form. Everything works fine exept for one thing, The sub form only appears in datasheet view. When i am in design mode everything seems fine, and when i select View>Form View it comes up ok, however whenever the form is running...

Please help... I have a query that prompts for 2 dates, then is supposed to retrieve all invoices between the 2 dates. What expression do I need to use to make sure I get the desired result? I cant compare the two dates using the > operator

Thanks the answer was a lot simpler, what i used was - Field: Year([date field]) Criteria: Year([Enter date])-1

I need to build a query that shows all invoices for the current month a year ago. What i want to do is prompt for the current date(not a problem). Then I think I need to somehow take a year away from this date and look for all the invoices for that year in the current month only. Does anyoone...

I am new to queries so forgive me if i appear a bit lost. I am construsting a query to show me unfufilled product orders and the products that have not yet been delivered yet for each product order. I have joined 4 tables Product Order, Product Order Line, Supplier and Product. What i want to...

Why is when i add the combo box, if i enter an invalid customer ID a record is still retrieved, am i doing something wrong or do i need to change something??

Further to my earlier post, this is what I am trying to do. I have created a table where a customer record can be created, a customer ID is assigned via autonumber. Now on a seperate form, i want to be able to enter either the customer id or name and press search and the relevent details come...

If I have a form that shows Customer details(customer ID, Customer first name, customer surname) how can i add a button and make t search on the first and last name entered???

I have just created a table and form to enter Customers information. I have set the primary key for Customer ID to autonumber, so for each new record Access automatically assighns an available number, however when i open the database the New Record button is grayed out. So how do i add a new...

ok thanks for the help dude, do u know any good site s with access tutorials??

Hi I am new to Access, and need to know how to do the following, and if it is possible. I have three tables One has Supplier ID as the primary key The next has Product Order No as the primary key and Supplier ID as the foriegn key The last has Supplier Invoice No as the primary key and...

jjh