Search results

The following is the Code i have in Access in SQL. I've just started to learn it and wanted to see if anyone could help. All of the code works to perfection like it should. however, i wanted to know if it was possible to have a Code which would ask for two numbers in the beginning and would...

1 query for multiple tables. So i have just completed my database and everything works fine. Now, my managers wants me to go back and do it again for other internal companies. Mind you that we have over 100+ and i am not in the mood of going through and doing something that is not my job...

Here’s my goal. 1.) I have one column and want to add a 633 in front of if. a. Expr3: "633 " & [Grp] & "" b. This only shows 633 and asks for an entry for the GRP? Why? I want the format to be 633 xxx. If I do add, lets say, 123 in the popup, all of the columns are 633 123. 2.) After...

I am currently a newbie when it comes to Access but I am really proficient with excel. I have been given the task to update our query in a database in which everything that is blank has the work "empty" in the field. I get the entire query to work but can't get the iff statement to work. I...