Search results

I get #Error in all cells when looking at the query and also the report if I add in the field.

Sure did :confused: Dont know if it will help but this is my SQL I might have made a mistake? SELECT tblBedSlot.aphCenter, tblBedSlot.beginTime, tblBedSlot.endTime, tblBedSlot.dayOfWeek, Weekday([dayOfWeek]) AS DoWSort, tblBedSlot.clinical, tblAphCenter.chairsQualifiedByQA...

Ok, I am really trying to get this :o I try to add DOWSORT: Weekday([dayofweek]) into the qry and I get #Error in all the cells. I have no idea how to add that into a report if thats what you ment for me to do. Lastly I just want to make sure that I understand this Function: If a Cell in...

Works but I have a problem, I need to Group On "DayOfWeek" and also sort Sun-Sat I have set it up a few differant ways but I always get an error. ORDER BY clause (Weekday([dayOfWeek]) conflicts with GROUP BY clause

OK, I really did search for this but I only go information on how to sort a Date (1/1/1900) to Sun-Mon. What I need is a text field that allreay has the day of week sorted. Below is what i have now: This is what I want it to look like on the report Any Ideas?

Bah I got it DoCmd.OpenForm "frmAphBedSlotDetail", , , "[tblBedSlot.id] = " & Me.lstMon.Column(0)

Thank you for that I will have to keep that site around! I still get a error with this code... Not sure why, it pulls the value correctly. Datatype mismatch Private Sub lstMon_DblClick(Cancel As Integer) 'If the user double-clicks in the list open the details frm If Not IsNull(lstMon) Then...

I have an unbound list box that is found in a SubForm. I want to use the following code to open a details box so a user can edit that list item in...Detail. For some reason my code is not working I attempted to follow the article in this link...

OK! I have attached the final DB layout, I am still haveing issues reporting on the data as it duplicates records :confused: But I am sure I can work on that. If anyone is willing to take a quick look over the relationships real fast and if you want to look at the report for me thats cool...

Good point! I will make the change!

Ok, so I thought about this over the weekend and I think this setup below should work. Feedback? I will post a DB file with the test data soon. I will include a Report, Qry and entry form. (If it all works lol) NO LOOKUPS! lol

Commandments are now on my wall :) I dont know how to make my tables better, I thought they had been setup ok...Thats why I need help :( First off, that was a mixup sorry it must have happend when I was trying to import the data by hand. You are right Questions need to go into tblQuestion...

I attached the most up to date one, just in case, thank you for any help

Ok I have done my best to get this thing to work; I spent the last two days trying Deadline for my project is getting closer and I am stuck. I think the relationships are looking better but I have a major issue that I cant figure out... How do I import my data? I have a table "Import...

Looks like I got the qry thing figured out, we will see :)

I think I fixed the issue with the Options not being linked to the question. But I can not do any qry on the tables or get a form to work? I am still missing something... I have attached the DB so you can take a look

Bump, No other comments? I assume this means I got this figured out?

Ok I think I have this down, please keep in mind this is only the second DB I have had to make from the gound up :eek:

Very well said!! I will work with the folks that come up with the questions and try to get a standard set. Let’s assume that we only have ONE set of questions, moving forward. I still have basic issues with storing that data? I need to create a relationship the ties the Comments and...

Uploaded my DB, I hope its helpfull