Search results

Thanks so much.........I'll try the concept!

I am trying to create a report that needs information from many calculating queries. The reason why I do not create one query to do all my calculations is some calculations create another level of calculations based on the previous query do to grouping, summing etc. I was wondering if I could...

I didn't want to get mixed up in the controversy..... but Pat & Rich you were right..... I am NOT using the TABLE as my control source due to the fact of minimizing my combo box listing for look-up purposes for the user. Pat, I am going to try your suggestion, it makes a whole lot of...

I am having a problem with a form. I have created a form, (in order to make changes to a Table) with the control source being a select query and not an actual Table. I created a combo box to search for the record along with the rest of the fields in that record. I search for the record to be...

JON ..... THANK YOU SO VERY VERY MUCH ! CREATED THE QUERY LIKE YOU SAID AND IT WORKED OUT FANTASTICALLY ! THIS WILL SURELY SAVE US A LOT OF TIME. THANKS AGAIN DM;)

I am trying to develop a unique key from a make-table query that selects records from user-specified date range. I am trying to extract the last record from the selected date range of meter readings. Some meters may have only 1 record while others may have many readings for the selected date...

What is the best way to place a parameter value specified in a query to be placed on a report based on that query? Thanks..Diane

I tried the function when I created a MAKETABLE Query....but I received a 'Type conversion Error'. The table was created with the Date/Time field for the numeric field, but it did not bring over the data. The error said the (date type) field doesn't match the destination field. I also tried...

I am importing a file through ODBC. One of the fields is a numeric field (which is a date). When I bring it into access is comes in as a numeric field, but I need to have it as a Date/Time field for query purposes. When I try to copy/append to a new table which I have the numeric field copy...