Search results

I am relatively new to Access and this question may be silly but I'll give a shot; I have been designing a company report based on the sales records exported from the company's accounting system. I already have an exported set of the last year data in Access. My intention is to run daily...

Mike, that's what I was looking for, works like a charm!!! Thank you very much to all who participated here, special thanks to Mike. Peter

Rural Guy, could you PLEASE update the attachment I posted here so that I can see what you meant. I'm sorry but I am not an expert in this.

Rural Guy, pasting your command into SQL View gives me an error: SELECT LQ2.description Function MyString(strIn As String) As String MyString = Mid(strIn, 6) MyString = Left(MyString, InStrRev(MyString, " Sub-Total") - 1) End Function FROM LQ2; The error message: The SELECT statement...

Guys, we can't build the function based on the context of the string (this applies at least to the left side side of the string). The "Prod" part of the string changes to something else. Please take a look at the attachment with the real data. I appologize for not being clear at the first place.

I need to trim the following query field: "LQ2daily.description" from both left and right side. The field contains text strings like this: FG - Prod - Mfg Sub-Totals --- FG - Prod - Mfg - Whole Grain Sub-Totals --- FG - Prod - Mfg - Egg Sub-Totals --- On the left side I need to trim "FG - "...

Ted, Thank you very much for your reply. Ted, indeed my intention is to convert the currency fields in the query and not directly in the tables. The three tables are linked with the accounting database and will be updated daily, that is not the issue. My problem is linking the “date” and...

I have a requirement to build a query based on three sales tables. The challenge is that the "product pricing" and "rebate" fields are in their native currencies (Canadian dollars, US dollars and Euro). The US entries are flagged with the "U" values, the European entries are flagged with an...

Thank you all who helped me with this issue, special thanks to you Mike! I think I'll be O.K. for now.

Mike, I wish if all files are simple as the first sample. I've attached another sample where you can see my real challenges. Thanks, though.

No, the "$" sign will never be there in my real files. I just posted as an example. All fields are string fields. Please find attached a sample of the original file. The file does not contain spaces before the first field. Yes, it will be always a space after the first field as well after...

I have a challenge importing a space-delimited text files into Access if one of the fields contains multiple words separated by a space. For example, the "Description" field: Date Description Amount 05/14/08 This is a first line $1234,50 05/15/08 Another line $9876.20 How can I tell Access...

EMP, just wanted to thank you one more time, though I didn't have chance to work on it today, it looks good from what I see. All the best to you, TX!!!

I was referring to the "Adv Track Shift", "Shift2" and "Shift3" as calculated fields in Query, not in the database itself. The table is part of MS Access database that is part our time and attendance software. Does that make sense to you? Now, I tried pasting it your criteria in the Query but...

Please find attached a sample query... Is it possible to create the following logic in query: "If there is a "SHIFT2" or "SHIFT3" value on the last Friday in month, then change the date values for these entries to the next date (Saturday)" In the attached sample, there is a number of such...

Mr. Mailman, Problem solved!!! Tx, Peter

Is it possible to group and summarize fields while in a query instead of doing it in the report section? Please find the query attached. For each day, I need to group the "Expr1" field (shifts employees worked) and "Date" field and to summarize their corresponding "Cases" and "LBS" values...

Gentlemen, after your suggestions, I learned that I was suppose to paste it into the SQL mode and it worked! You made me a hero here, I truly appreciate for your time and effort in this matter. Cheers. Peter

Mr. Mailman, Yes, my regional settings are American. The short date format in my settings is MM/DD/YY and long date format is MMMM d, yyyy. I pasted the expression in the design window; I am not familiar with the SQL expressions. Was I supposed to paste it as a SQL command, instead? I am a...

Paul, I probably haven't explained to you properly and I appologize for that. The end result is to convert the entire text field from the table to the following date field format in the query: MM/DD/YY. I pasted the above expression in the query but it returned an error: "The syntax of the...