Search results

I have a table with multiple fields and each record in the table may not have data for all fields. I need to write a query that will pull only the fields that are populated for each record from the table. Any help you provide would be appreciated. Thanks

Could you let me know how to suppress record navigation buttons in a report? I am using the results of query that has multiple rows to create a chart. BTW I am using access 2003. Thanks for your help

Friends, I am trying to create a query where I need to use the value of a field in record #1 to calculate the same field in record #2 and value in record #2 to calculate the same field in record #3 and so on. Can someone provide guidance on how to accomplish this? Thanks for your help.

Can some one guide me posting an example to retrieve data stored in an one-dimensional array using a select query? Thanks in advance for your help.

I need to find the difference between values of two consecutive rows in the same column of a table. Can some one help me to write a query to do this? Thanks for your help

I have two tables Table 1 and Table 2. Table 1 has 6 fields 175 records and Table 2 has 4 fields and 330 records. The first three fields in both the tables are the same. I need to find all records in the first table that have a matching record in the second table based on those first three...

I have four different forms which are linked to four different tables. Each form has a field called RECORD_ID and I would like to increment the RECORD_ID sequentially based on the last number that was assigned for anyone of them. Is there a simple method to accomplish this task?

Is it possible to display a set of fields on a form based on a selection from a combo box located in the same form? If it is possible, how do I do that? All the fields are on a single table and the display has to change depending on the combo box selection. Any help would be greatly appreciated.

I have a query that returns values for two fields. In some cases, null values are returned and I would like the query to return the value 0 for both of them instead of a null. Can anyone a suggest a method to accomplish this? Any help would be greatly appreciated.

I have a list box on a form and I would like to give the user the option to select multiple items from the list. How do accomplish this and pass on a single string to the query to retrive the records based on the multiple items. As I am not familiar with writing a code, I would greatly...