I have this query, but it needs to work as a view in SQL Server:
SELECT tbl_raw_material.raw_material_id,
[packaging_type] & 
IIf(IsNull([packaging]),"","|") & [packaging] & 
…

I have all change in mysql server syntax but just  ((IIf([WHPrep]![Inprogress],"Yes","No"))="No") is create error ,How can I change this condition  for mysql query .I did not understand ! symbol …

I have a file path and I want that file path to include whatever the PCs Name that I am currently on. Such as...

(CODE)

So how would I make the VBA understand my current PCs Name?

Thanks.

I have a query of 2 tables with a join on acct number and another field that produces a typical horizonal result. However I need to make it vertical of field names and value.Is this possible - any …

I have three fields in access table.  They can each contain either a number, or be null.
[ON_HAND_QTY]
[WIP_QTY]
[Pending_Qty]
The formual is  [ON_HAND_QTY]-[WIP_QTY]-[Pending_Qty]
but if any …

I have this in a standard module

Public Function EndDate0(Ender As Boolean, Start0 As Date, Start1 As Date, Start2 As Date, Start3 As Date, Start4 As Date, Start5 As Date) As Date


If Ender = …

I created a table with two fields.  one the same as another table so I could create the relationship.  (However not sure that is needed)  The second field is used for data.  e.g. Abandonment, Guard …

I have a database where information is stored in a table.  There is a column names "Errors".  If there is at least one value in one of the error fields I want to run a macro, otherwise, if the Errors …

Hi
I am writing an ms/access app that needs to print ID cards from a table. in the table I do have an hyperlink to the ID image. How do I do in the report to substitute the hyperlink by the …

Can anyone tell me how to identify the name of a missing DLL in Access 2010.
The Access 2010  application I'm running is loaded onto the local C drive of about 10 PCs (Access 2010 frontend database …

I have a database in both Access and Excel with 6 columns and 816 Rows, I want to create a search and retrieve windows app using VB.Net, please help
Thanks in advance

I have  a table
let say that the fields are:
Rec#
StartDate
Status and so...
i need to calculate the number of days between StartDate and today
in excel i will use NETWORKDAYS(Date1,now(), list…

I have a table with SellPrice and Cost. I need to find out the percentile difference (Profit) between the two and display it as percent. So, if SellPrice was 100.00 and Cost was 50.00, the Profit …