Search results for query: *

Hey folks, I need your help here yet again. I have an educational database of courses that I'm trying to get the following results from a query: Course Name Session Avalability Session Time Location Blah June 9/05 8am Dallas June...

I think I've once again solved my own issue. I ran into a mess of problems, as this make table query would die on me due to the relationship I established with another table. As such, I just kept the table and relationships and primary key that I had initially created. The user can delete the...

Okay, 1 last thing with this. I've set up the relationship appropriately so this works great. The only way it works is for me to define the field COMBINED in the table tbl_Authenticated_Numbers as a primary key. As I want to make all this seamless to the user, is there a way to define this as...

AWESOME, this is exactly the way it's supposed to look!! Thanks,

So how exactly would this look as a SQL statement? I've tried it, but the Query bails on me each time, so I must have something incorrect. I tried the following: SELECT Format(Val(ac & bc & cc & dc), '@@ @@@ @@@@@.@@@ @') AS COMBINED INTO tbl_Authenticated_Numbers FROM tbl_Numbers The final...

why are you storing formatting info instead of just displaying it at runtime" I don't get you? I have 4 seperate numbers that alone mean nothing, but when combined form the unique identifier number. Thus the need to combine them. "Have you tried to play with the Format function in the SELECT...

Okay, I'm not sure if this is possible, so I'll describe the situation. I have data in a text file (comma delimited) that I import into an access table. The data from the spreadsheet consists of numbers (a different number for each field). Together they form a unique number for the client. A...

Yeah I initially tried the val and format, but couldn't get it to work. As such I just created an update query that does this: UPDATE tbl_accounts SET tbl_accounts.actnumber = Right([actnumber],8); Works like a charm.

I have a table with a field that has a number (stored as text as it's used to identify items and never used in calculations) that is a total of 18 characters long. The actual number that the user sees is 8 characters long. I need to strip out the first 10 digits in this field. Anyone know how...

Who has access to your database? Or should I say who has the required access to delete records? If you deleted 2 records, then this is normal as KenReay mentioned, it's the way Access works... Or if the users are able to delete records, then this is also okay as you've allowed this and...

It worked correctly from the get go... For some reason it wasn't working on Friday, but it's working now... I did have to change it ever so slightly to allow a space in between the first and last name: SELECT FirstName & ' ' & LastName AS comprehensive FROM tbl_names

Ahhh, okay it must have been due to it being a Friday, this works fine... Crazy!

Okay, I'm wracking my brain here and can't find the answer to this one... I have a table (lets call it tbl_names) with 5 fields (for this lets just use 2 and call them FirstName and LastName) that I need to join together to make one field (lets call it Name). Now I've created a query that...