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

Yes, I am sorry they are page navigation buttons. How do I suppress them? 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

Can you help me with an example? Thanks

Assume we have three records. RECORD id Value 25 1.2345 24 value1 23 Value2 Here value1 needs to be calculated as 1.2345 * 4.75 and value 2 to be calculated as value1 * 3.25 The key point is I know the value only for the record ID 25 which 1.2345 and...

Thanks for your response. This subquery pulls the data value from previous record but I need to use it to calculate the same field in the next record and so on. How can I do it? Thanks

Actually the ID is sequential but descending order beginning with #25. The second will have the ID #24 and so on. I need to use the value corresponding to #25 in #24 and #24 in #23 and so on. Thanks

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...

Thanks Jack.

Could you please elaborate on that giving an example if possible Thanks Jack.

Hi Jack, I need to increment the RECORD_ID by 1 based on the max RECORD_ID in the four tables. Is there a way to use the DMAX function to find the max for multiple tables. Thanks for your response.

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?

Hi Jack, All I need to do is to display a set of fields for data entry based on a selection in a combo box. This combo box will appear at the top of the form.

Hi Varunmathur, Thanks for your prompt response. If I have say twenty fields that I need to display, should I have to set the visible property to "Yes" for all the twenty fields in the macro. Is there a shortcut to do this? Thanks once again

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 tried NZ function but it didn't work. I am still getting null values instead of zeros.

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.