could you please give me some more info on how to do the above. Thanks

Hi, I am trying to workout a way that I can run a query that will search a number of columns and bring me the latest date back for that id...

Hai,to every one here is my question I have designed the coding to collect the feedback report from the user ,which includes Name of the user, staffno and...

Playing around with Subqueries I've noticed that whenever I do anything to change the query in the Design view, a bang (!) appears just in front of...

I am looking to move data as a whole, not sure if what I am looking to do is possible or just wishful thinking. Setup: I have a database with several...

In my job I currently use Excel to track information. I have a group of employees that provide treatment to a large list of patients each day. Every employee...

An event that calls a query is returning a run-time error and I can't seem to figure out why...I am sure it is probably fairly simple, and would appreciate...

and select the critera from the choices in a field. I know creating a search Parameter , but the problem is that the person doing the query has to spell...

Hi, I'm not sure if this is the correct place to place my request for help, but hopefully someone can help or steer me in the right direction. I have the...

Dear all, My mother-tongue is not english.So if there's something I cann't express clear,pls be tolerant,thanks. There are two tables,with the same field...

I have been given a database, which has been used to record incoming calls, the user enters the time someone phones in, the department name and person they...

How can I determine number of weeks between 2 date with decimal precision. let say if the was a delta of 6 day between 2 date return 6/7 = 0.86 I tried the...

Hello, I want to get the date in the right order with using statement below: "SELECT tDate FROM TempTB ORDER BY tDate;" For example, if the list of...

I asked this question before and didnt get reponse but I think I didnt ask it properly nor provide the appropriate information. I am hoping to have explained...

I wish to update the MedRecord in Table IntakeInfo with thePatientMedicalRecord# from the Table PatientInfo. PatientID is the pk in PatientInfo. There is a...

I'm not sure if this has been covered here. I have a form that adds individual purchases to a customer's account, updating a table that records the item...

Hi, is there a way to rewrite this code to make it short. The query won't run because it max the # of characters allowed. sorry it's written in caps. thanks...

I have the following expression in a query: Actual Month: Sum(IIf(Len(=3),)) basically I want a sum of quantity if the length of header = 3. But...

I have a subform that creates an unbound text box based on user questions. It creates a document format that I want it to query on using the "like"...

I'm having a complete brain fart and cant find it in help. what is the formula to return a value after a specific character. the most common example is...