Search results

Don't worry about it I got it. Thanks!

I tried to put this in the query SQL but it doesn't seem to work. Any idea why? Thanks!! SELECT FTLookup.TransportationMode FROM FTLookup WHERE FTLookup.Linehaul# = 'Legs.[1st Linehaul #]'

Hi, I have the following problem. I have three tables, Main Table, Table A and Table B. All three tables have a field called "Cutoff Time". The Main Table will look up the info from Tables A and B. Table A has a field called "Service". In the main table, there is also a field called "Service"...

Thanks for the tips! I will try it out later.

Hi, I need some help with the following problem. Thanks in advance! I have imported an Excel spreadsheet into Access database. I will need to constantly add new entries to the tables. I need to connect all my tables together, the main table is called "Data". From looking at Access examples, I...

Thanks Rusty. But the problem is if there are two fields only, an extra slash appears at the end of the combined field. Sometimes the number of fields can go up to 10 fields. So if I do it the way you did it, there needs to be 10 slashes but the user might end up inputing two fields only, and...

Rusty: This will be in a query. Thanks. neileg: Actually there will only be at most 10 codes, and they could be three or four letters each. The user will input the codes and I need to combine all of them and show it to the user in a query. Im not sure if this answers your second question...

I'm writing a field where it shows a combination of many fields. For example, when a user types in "abc" in field 1, "def" in field 2, "ghi" in field 3, I will have to combine the three fields into "abc/def/ghi" with slashes in between them. However I don't want to have any slashes at the front...

This one worked Right([Orig],Len([Orig])-1) Thanks!!

Thanks for your reply. But the number of characters in the field varies. Sometimes it is d123 sometimes it can be d12345, etc.

I have a field which looks like this - "d123456", I will have to display the field without the "d" in front, meaning I will need to show "123456" Any idea how I can do this? Thanks!

Thanks guys. I did Newman's way and it worked. The thing is I'm asking the user to input the Orig Dest, I'm simply pulling info from a table. But thanks for the tips I will remember it for reference! Thanks again.

Thanks guys for the help!!! I'm chewing all the info now.

This is what Im not sure about either. I know how to use SQL statements, and since Im not sure whether Access can do all the things I can do with SQL statements, it seemed to be a good idea to combine both. Im reading a VBA book on Access but I lost track of all the relationships, Access, SQL...

I was wondering how to go about combining both Access and SQL together. Am I going to write the SQL codes in VB and then Access will know how to combine the tables I've created with the SQL codes? Thanks in advance!! Jason

How do I query from a table with a specific field (region, for example) that I need by feeding in another field (location) from another table. The table with the region field has the matching locations. The user will input the departure and destination location and I want it to look up the table...