Search results

Is it possible to add a <br> after every full stop within access? I currently had a description field that contains carriage returns. What I wish is add a <br> after every fullstop instead. Can it be done within a query? Example I currently had a description field that contains carriage...

Hi all I have a current file with GBP 12.00. I wish to remove the GBP in a make table query when ran to print off.

Is it possible to create a simple select query in order to place after a full stop within description column.

I have just tried that and its asking for vbCrLf in a dialogue box.

could you translate that into the form of query for example Expr1(example)

Query to change carriage returns and breaks to <p> and </p> Hi all I'm struggling to get this work but I currently I have a database with description. This contains carriage returns so it looks like Product A Description A Description B Description C however ebay file exchange will not...

Hi I have just figured it out. I used Total Stock: Nz([Quantity],0)+Nz([Virtual Stock],0) and it worked.

I'm racking my brains with this one I have a table called inventory and I wish to add Quantity + Virtual Stock together in a simple select query. However it does not seem to display anything.

Does this also include spaces?

Hi all, Please can I have the command to select first 30 characters in a simple select query.

No, currently I just have Date() However there is a field within my table called "Date Done" Nevermind I've figured it out. Thanks anyway.

Pretty self explanatory, but I would like to create a query that displays a date like this "20130315" Can this be done?

how does that work, or more importantly what would the code be?

Hi all I have an inventory table with a column of SKUs, I wish to create a simple select query that takes the first 3 characters of the sku and displays it. any idea how?

Hi all, I wish to create invoices based on customer orders to mail with items they have purchased. I would like the report to be based on an order id that combines any items based on that ID to be listed in a table and each customer has their own page. Is it possible to do this?

yes that's what I'm saying

Okay at the moment we have to download orders and we which to give the postal services a code based on shipping_method column. For example Royal Mail Tracked will be TRD, First Class will be FC and Second Class will be SC. So the IIF staement will go if Royal Mail Tracked it will be TRD, or...

Hi all I need some help mainly with an IFF statement based on shipping_method Royal Mail Tracked (2 to 3 working day delivery service for orders up to 2pm) will be TRD Royal Mail 2nd Class Recorded (Ships normally within 3 to 5 days) will be SC Royal Mail 1st Class Recorded (Ships normally...

No no I don't want to actually update the table, when I run the select query I just want it to not include the asterisks.

Hi all I'm looking for some code to delete * from both start of an order ID and end of order ID currently it looks like this *23627367236327*. I want it to look like this : 23627367236327 row is currently called order-id.