Search results for query: *

Thanks Ken In the report - if on the form the user selected * - the report shows * instead of the field value (such as Division 2). I found your faq post on this as well. I will try again. Thanks

Ken Can you explain what your SQL statement is doing? sorry - it isnt working but i am not getting an error so i am not sure what i have done wrong. thanks [sad]

Sorry - i am quite new at this and also not being very clear - thank you for your help so far. I will work with your query as i believe that is what i want. Only append if it isnt already there. The problem is i do not have a unique field rather i want it to find unique records - so all...

Thanks Pwise. The problem is the whole thing would need to be looked at - as they are records of transactions Date, Loc, Record# (would be unique except that it can be blank), follow up etc. so they can have multiple entries from the same location on the same day. The entire record would have...

I have a database that obtains all of its data from an excel spreadsheet. I have a macro that does the import quickly to a temp table then an update query that will put it into the permanent table. I am looking for a way to write a 'check' that will tell me that record already exists before...

Thank you Ken. Let me go try that and see if i can make it work. I appreciate your help.

Hello, I have a report that the user would like to have quite flexible. sometimes they'd like it limited to a certain date the next time - all dates and only specific employees etc. I know how to do a parameter query - and i know how to have a report linked to a form so they can enter the data...

IcesMaster How do you do that? [surprise] Thanks

Jeremy, Thank you for your response. I know the table is not well designed and it could be done better. If i HAVE to leave it as is for the time being is there any way to solve the issue otherwise? Thanks [bigears]

I have a table that contains dates and Locations as well as detail regarding events.(all one table) I need to create a report that shows me Location and Date at the top of the page and then underneath every event that happened at that location on that date. I keep getting it shown as different...

Thanks so much!

Thanks Fancy Prairie, Can you tell me what this means Dim cnn As ADODB.Connection I know I could just copy it but I'd like to understand it as well. Thanks so much for your time! I will go try this.

Hello, Can someone offer some advice. I am trying to write a little function that when called will run a query to tell me if there are matching records in the two tables - if there are i need it to give me a message box stating so. I had tried once and could not make it work. I am looking in an...

Sorry, I should have mentioned I'm not too swift with all this yet. What if i want only the records where ALL fields match except the autonumber PK - would i do the INNER JOIN Permanent_Table ON Temp_Table.testfield = Permanent_Table.testfield AND Temp_Table.testfield2...

Thanks! I'll try it right now...

Hello, I have an append query that updates a permanent table with data from a temp table. (the temp table contains data from an imported text file). What i need to do is BEFORE the append query is run I'd like to make sure that the data in the temp table is not already in the permanent table...

Hello, I am new to the site - desperatly seeking help. I have an Excel sheet that is linked to a table in Access. Is there any way to add a unique identifier to use as a primary key? Any help you can offer would be well appreciated. Thank you. Tal