Search results

I have not but will give it a try.

It's a weird situation that I don't understand. When we open the file it has an A column that is compressed to the left to where you don't even notice it when you open the file. I'm sure that I was not aware of it when I first linked it to an Access table. Btw - the data is shipment information...

It is an .xlsx file

Thanks Pat! Very interesting. I will take some time and see what I can modify to incorporate the the information that you have provided into the process.

We can delete column A. The hope was to just save the file from the email to the specified location and have no other intervention. Otherwise it requires opening the file each time and then deleting the column and saving it to the location. It's one extra step but it's annoying.

On the link it does not give me an option to specify columns. Import does.

Yes, that's probably what I am going to have to do. Thanks!

This is a weird one - may not be a great solution to it - wondering if anyone has any insight into this.. I have a database that uses an Excel file as a linked table. I have to use the Excel file as a data source as this information is sent from a vendor to us. The Excel file has column A that...

I believe this will work. I was hoping to not have to create the table with all of the extra dates but I can live with that. Thanks to everyone who replied! One last thing - if anyone cares to respond. I still have one last issue that I think I can work around (somehow). My table with the...

Thanks but I don't think this will work for me. See my reply to theDBguy

Thanks. This might work. I just have not figured out exactly how this translates to my query. I have one table and it has dates. like this: 1/03/2023 6/13/2023 6/30/2023 7/07/2023 I need to return a list of results showing the starting date (1/03/2023) and the ending date (7/07/2023) and a...

I need to see if there is a way in a query to list rows of date vales between a given starting and ending date. Specifically the issue is - I have a table that has records with date values in a field. If for example my first date is 7/1/23 and my last date is 10/3/23 - I want to return a list of...

Roger that.

Yes. I think that works/ Preliminary results look good anyway. Thanks!

I do understand that. This is however a very basic application. One table and one form. I can certainly create a form that opens, instead of the table. Just don't know if I am going to have the same issue. Will give it a try.

This is small conundrum but nevertheless kind of interesting. I made a form that is based upon a table. The form is just for entering data one record at a time. On this form I placed a button that opens the source table, for viewing in the more concise table view. I have noticed that if you...

That looks like it does the trick. Thanks, appreciate it.

Having a hard time putting a title on this one. This is odd. I seem to never have come across this before. Also possible that I am going senile and missing something obvious. Trying to figure out how to do this in a query. Example below. Let's say I have a table that looks something like this...

That works Mark - thank you very much!

I must be missing something obvious on this. I have a query where I want to calculate an average of numbers in grouped field. I am simply using the QBE grid and then Totals - and then selecting the filed, and Avg. The results are displaying like this: AvgOfLENGTH 133 128 119.8 126.4...